i need to show that column c is or = column a or < or = column b to be true
and displays acceptable then false if < column a or column b and displays
reject

mnoble wrote:
i need to show that column c is or = column a or < or = column b to be true
and displays acceptable then false if < column a or column b and displays
reject

I assume you mean to compare corresponding cells in columns A, B and C.
Replicate the following formula in each cell in column C (starting
with C1, for example):

=if(or(C1 = A1, C1 <= B1), "Acceptable", "Reject")

Note: Your "reject" logic is not consist with your "acceptable" logic
above. I presume you mean: "if < column a AND column b, display
reject". That is the opposite of "if or = column a OR < or = column
b".

Assuming source data (ie numbers) running in cols A to C, from row2 down

Put in D2:
=IF(COUNT(A2:C2)<3,"",IF(OR(C2=A2,C2=B2),"Accept able","Reject"))
Copy down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mnoble" wrote:
i need to show that column c is or = column a or < or = column b to be true
and displays acceptable then false if < column a or column b and displays
reject

Oops, correction to earlier ..

It should be in D2:
=IF(COUNT(A2:C2)<3,"",IF(OR(C2=A2,C2<=B2),"Accep table","Reject"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Can anyone write this formula in VB? I'm trying to write an Excel IF STATEMENT in VB so I can loop it, but I'm failing miserably...

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com