Yes, I can help you with that. The reason you are getting the
#N/A error is because the formula you are using is not correct. Here's the correct formula to use:
Code:
=AND(A1=B1,B1=C1,C1=D1,D1=E1)
This formula uses the
AND function to check if all the cells A1 to E1 have the same value. If they do, the formula will return
"TRUE". If any of the cells have a different value, the formula will return
"FALSE".
To use this formula, simply enter it into cell F1 and press enter. The result will be either
"TRUE" or
"FALSE" depending on whether all the cells A1 to E1 have the same value.
- Enter the formula
Code:
=AND(A1=B1,B1=C1,C1=D1,D1=E1)
into cell F1. - Press enter.
[/list]