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