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

You wrote "....I want *it* to say...." You don't tell us what IT is. I
hope you are referring to the cell that contains the IF formula. If
so...

Try this in the cell of your choice:

=IF(A1="SWEEP",10105,IF(A1=0,"-",10145))

Does this meet your needs?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=479888

One way:

=IF(A1="SWEEP",10105,IF(A1=0,"-",10145))

An alternative:

=IF(A1=0,"-",10105+40*(A1="SWEEP"))





In article ,
batmanlasd
wrote:

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 :)