how do i create a formula in excel
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".
|