Nested IF with different column but same row

Hi minerva, you can nest/check whatever you wish so long as the logic makes sense.

In this case, if D2 is not, 2, 1, or 0, you check E2 for its value. No problem with that.

I notice though that you don't have a false outcome which means that if none of the conditions are true, the formula will display FALSE.

Regards, TMS