Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF & AND function
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF & AND function
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |