Problem with nested if in excel 2016

[araujo3rd]

Hi guys for some reason excel will not accept my simple nested IF function that goes like: =IF(D2=0,B2,IF (D2=32, b3))

keeps telling me there is a problem with the formula?

[Sun13Banjo]

There's a space after your 2nd IF


Sun

[Khalidngo]

Hi @araujo3rd,

Excel is very smart. If you enter this formula you will get a pop-up:
Excel found an error in the formula you entered. Do you want to accept the correction proposed below?

Click Yes, and you will get the correct formula.

On a side note, you haven't mentioned the 2nd FALSE result... for example what if the values are other than 0 or 32?

=IF(D2=0,B2,IF(D2=32,B3,"what else?"))

Regards,