IF & AND function
see whether this helps you
in C2 type
=IF(AND(A2=A1,B2=B1),"ok","not ok")
and hit enter
now copy formula in C2 down the cells in column C
==========================
"Paul" wrote in message
...
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
|