If 3 cells are equal then...
 

Hi there

Cell a1, b1, and c1 will contain column headings
Cell a2, b2 and c2 will contain numbers
The numbers should be all the same, but of course life never works out
as it should! As such in D1, I want to put a formulae that compares the
three, if no difference then put "ok", and if there is a difference puts
the number of the difference... (may not be possible because u will
never know which is the correct number... so if not a number just a text
that says "problem")

Ideas are more than welcome!!

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***

If 3 cells are equal then...
 

=IF(AND(A2=B2,A2=C2),"OK","Problem")

HTH
--
AP

"Darin Kramer" a écrit dans le message de news:
...
Hi there

Cell a1, b1, and c1 will contain column headings
Cell a2, b2 and c2 will contain numbers
The numbers should be all the same, but of course life never works out
as it should! As such in D1, I want to put a formulae that compares the
three, if no difference then put "ok", and if there is a difference puts
the number of the difference... (may not be possible because u will
never know which is the correct number... so if not a number just a text
that says "problem")

Ideas are more than welcome!!

Thanks

D



*** Sent via Developersdex http://www.developersdex.com ***