Formulas

[Jim Pfab]

Here is what I am trying to accomplish:

a2=100
answer in cell f2
b2=x then a2*b1 or
c2=x then a2*c1 or
d2=x then a2*d1 or
e2=x then a2*e1
The x will be only in one cell in a row (b1,c1,d1 & e1 will have different
%)

Thanks, Jim

 

[David McRitchie]

Hi Jim,

F2:
=a2*IF(b2="x", b1,IF(c2="x",c1,IF(d2="x",d1,IF(e2="x",e1,0))))

 

[Jim Pfab]

David,

Thanks a million, it is doing what I wanted.

Jim