View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how do i create a formula in excel

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