IF & AND function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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
 
Thanks for the help, it's appreciated.

Paul

PeterAtherton said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set non-continuous PrintArea via Function / Name 0
Comparison of columns using Conditional Formatting 3
excel "IF" function... is this possible ? 0
Prob an easy one: How do i copy a formula EXACTLY as it is 9
Complex IF formula 4
VLOOKUP 1
how to use if formula in list (data validation list) 1
Lookup / Summary Table 8

Back
Top