IF Stament formula nesting

[batmanlasd]

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 doesn
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 I
statement :cool

 

[swatsp0p]

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?

 

[JE McGimpsey]

One way:

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

An alternative:

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