cell value

[Steve Kay]

Hi, Can I ask how to use a value in a cell .. in an
equation.

example: A1 has this equation. =IF(E8=100,"200",IF
(E8=200,"400",IF(E8=400,"1000")))

I would like to use the results fo this in another
equation. Thanks Steve

 

[Frank Kabel]

Hi Steve
problem is your currently return strings from your IF function. Use the
following instead:
=IF(E8=100,200,IF(E8=200,400,IF(E8=400,1000)))

 

[Guest]

Hi Frank:
Thank you. I need to use the results from this
equation.. and place it into another equation. Can that
be done?

 

[Frank Kabel]

Hi
e.g. if you want to multiply this with a factor use
=(IF(E8=100,200,IF(E8=200,400,IF(E8=400,1000))))*factor

 

[Steve Kay]

Hi Frank..

Actually: Use this results of this equation either,
200,400,100 into this equation.
=IF(E9>1, (results here))

so if there is a value less than one.. take either
200,400,1000 and paste it here. Thanks again

 

[Frank Kabel]

Hi Steve
one way:
=IF(E9>1,IF(E8=100,200,IF(E8=200,400,IF(E8=400,1000))),0)

or
=(E9>1)*IF(E8=100,200,IF(E8=200,400,IF(E8=400,1000)))

both formulas return zero if E9 is not >1