IF Stament formula nesting

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

One way:

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

An alternative:

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





In article <[email protected]>,
batmanlasd <[email protected]>
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