cell value

  • Thread starter Thread starter Steve Kay
  • Start date Start date
S

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
 
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)))
 
Hi Frank:
Thank you. I need to use the results from this
equation.. and place it into another equation. Can that
be done?
 
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
 
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
 
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
 
Back
Top