IF & AND function
Thanks for the help, it's appreciated.
Paul
"PeterAtherton" wrote:
Paul
I don't know about row 3 but try this
=IF(AND(A3=A2,B3=B2),"Good",IF(AND(A2<A3,B2<B3), "Neither columns
agree",IF(A2<A3,"A1 & A2 Don't Agree",IF(B3<B2,"B1 & B3 don't agree"))))
Regards
Peter
"Paul" wrote:
Hi,
Can any one help with a formula that does the following:
If A2 = A1 then B2 should = B1. If it does, then indicate OK otherwise
indicate not OK. The formula should also cope with A3 not equaling A2, where
it doesn't matter that B3 does not equal B2.
I hope this make sense.
Thanks for taking the time to look at my problem, your help is much
appreciated.
Paul
|