Formulas

J

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
 
D

David McRitchie

Hi Jim,

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

Jim Pfab

David,

Thanks a million, it is doing what I wanted.

Jim

David McRitchie said:
Hi Jim,

F2:
=a2*IF(b2="x", b1,IF(c2="x",c1,IF(d2="x",d1,IF(e2="x",e1,0))))
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm


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
Click to expand...
Click to expand...
 
Top