Example A6=Home
B6=40
C6=32
=IF(A6="home",B6-8,"Check")
The "Check" is whatever you want to have for the "FALSE" part of the
statement. You can also add another "IF" condition: The following
statement
is the same as the above for the 1st IF - the 2nd IF is adding 8 if
A6=Work.
=IF(A6="home",B6-8,IF(A6="work",B6+8,"Check")).
You can have upto 7 "IF" Statements in on formula.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640
View this thread: http://www.excelforum.com/showthread...hreadid=496415