View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default 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".