I am trying to write a formula in Excel that tells whether 4 cells in the
same row have the same value. The IF function is limited to 2 cells.

The IF function is limited to 2 cells, but you can nest up to 7 IF functions
within one statement. You can also combine IF with the AND or OR functions.
Try something like this:

=IF(AND(A9=B9,A9=C9,A9=D9),TRUE,FALSE)

Hope this is helpful.

Hutch

"ChrisMohler" wrote:

I am trying to write a formula in Excel that tells whether 4 cells in the
same row have the same value. The IF function is limited to 2 cells.

=IF(AND(A1=B1,A1=C1,A1=D1),"YUP","NOPE")


"ChrisMohler" wrote:

I am trying to write a formula in Excel that tells whether 4 cells in the
same row have the same value. The IF function is limited to 2 cells.

=countif(A1:B2,A1)=4

--
Regards,
Tom Ogilvy


"ChrisMohler" wrote:

I am trying to write a formula in Excel that tells whether 4 cells in the
same row have the same value. The IF function is limited to 2 cells.