Logical Formula

**Saturn** · 10-02-2011, 03:30 PM

I have 3 columns, let’s say A, B and C

If the row for all three columns contains a number I want to notify this in column D with a ‘YES’ (or with True).

If non, or just one or two cells in the row contains a number, I want to notify this in column D with a “No” (of False).

How is the formula written?

Saturn

**heyzeus17** · 10-02-2011, 03:36 PM

=IF(AND(ISNUMBER(A1)=TRUE, ISNUMBER(B1)=TRUE, ISNUMBER(C1)=TRUE), "YES", "Nooooooooooo")

or see attachment

**Saturn** · 10-02-2011, 03:42 PM

That easy!
Thanks a lot heyzeus17!

**Winon** · 10-02-2011, 05:47 PM

The ISNUMBER formula will only respond to any integers entered and ignores anything else like for instance "A" or "c" in any of the three columns. I would therefore suggest using =IF(A2<>0,IF(B2<>0,IF(C2<>0,"YES","NO"),"NO"),"NO") instead