I want to nest a formula with some if statements
Here is my data i.e.:
If my cell A1 equals "SWEEP" then I want it to say 10105, if it doesnt
then I want it say 10145, but if it equals "0" then I want it to say "-"
Thanks for the help in advance , my trouble is when I put the second If
statement :)
--
batmanlasd
------------------------------------------------------------------------
batmanlasd's Profile:
http://www.excelforum.com/member.php...o&userid=28400
View this thread:
http://www.excelforum.com/showthread...hreadid=479888