Prev: Total for Cells with same name value
Next: how do i calculate 2' x 4' x 4"
From: Scoober on 2 Mar 2010 21:07
I am trying to complete the following.

In s141 i have a drop list with 'yes' and 'no' as possiblities.

In x141 i have a drop list with 3 possible choices, .02 , .04 , or .08

g141 is the originating cell

p159 is the answer cell.

if s141 remains empty or has 'no' chosen from the drop list i need p159 to
remain blank, however if 'yes' is in s141 then i need the answer from g141
multiplied by .02 or .04 or .08 (which ever one is chosen from the drop list
in x141) to be displayed in p159.

Can anybody help?


Thanks in advance.

Scoober
From: T. Valko on 2 Mar 2010 21:19
Try this...

=IF(S141="yes",G141*X141,"")

--
Biff
Microsoft Excel MVP


"Scoober" <Scoober(a)discussions.microsoft.com> wrote in message
news:44D49EC9-C879-486F-BCE4-6B02C7CB8F86(a)microsoft.com...
>I am trying to complete the following.
>
> In s141 i have a drop list with 'yes' and 'no' as possiblities.
>
> In x141 i have a drop list with 3 possible choices, .02 , .04 , or .08
>
> g141 is the originating cell
>
> p159 is the answer cell.
>
> if s141 remains empty or has 'no' chosen from the drop list i need p159 to
> remain blank, however if 'yes' is in s141 then i need the answer from g141
> multiplied by .02 or .04 or .08 (which ever one is chosen from the drop
> list
> in x141) to be displayed in p159.
>
> Can anybody help?
>
>
> Thanks in advance.
>
> Scoober


From: FSt1 on 2 Mar 2010 21:49
hi
i assume that someone is going to enter a number in G141 and that S141 and
X141 are data validation so....
in P159 enter this formula....

=IF(OR(S141="No",S141=""),"",G141*X141)

regards
FSt1

"Scoober" wrote:

> I am trying to complete the following.
>
> In s141 i have a drop list with 'yes' and 'no' as possiblities.
>
> In x141 i have a drop list with 3 possible choices, .02 , .04 , or .08
>
> g141 is the originating cell
>
> p159 is the answer cell.
>
> if s141 remains empty or has 'no' chosen from the drop list i need p159 to
> remain blank, however if 'yes' is in s141 then i need the answer from g141
> multiplied by .02 or .04 or .08 (which ever one is chosen from the drop list
> in x141) to be displayed in p159.
>
> Can anybody help?
>
>
> Thanks in advance.
>
> Scoober
 | 
Pages: 1
Prev: Total for Cells with same name value
Next: how do i calculate 2' x 4' x 4"