If 3 cells are equal then...

[Darin Kramer]

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 ***

[Ardus Petus]

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

HTH
--
AP

"Darin Kramer" <darin_kramer@hotmail.com> a écrit dans le message de news:
utOb4q8qGHA.4988@TK2MSFTNGP04.phx.gbl...
> 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 ***

[dawn12789]

Can anyone help, when im trying to use your formula, it always shows a message saying



"We found a problem with this formula. Try clicking Insert Function on the Formula tab to fix it, or click Help for more info on common formula problems.

Not trying to type a formula?
When the first character is an equal (=) or minus (-) sign, Excel thinks it's a formula...


You type = 1+1, cell shows: 2


To get around this, type an apostrophe (') first:
you type : '=1+1, cell shows: = 1 +1