What he means by "check" is that as you are writing an "IF" statement,
you have to say what you want the value to be if true, and what if is
it false. So if you say L5 = home and S5 = 10 then you are correct
with the formula as it is written. However, if L5 contains something
besides "home", you have to indicate in the formula what you want
returned as well. If you don't want anything, and want it to be blank,
just enter two sets of quotes.

so:

=IF(L5="home",S5-8,"") for a blank returned.

However, since you have 'home' listed, I assume you have another
location as well that you don't want to apply the (-8) to, and just
want it to equal the mileage field without any subtraction you'd use
this:

=IF(L5="HOME",S5-8,S5)

HTH

-Scott


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