Try this...

=IF(R92<=0,"Not Completed",IF(R92<=1,"Acceptable","Unacceptable"))

--
Rick (MVP - Excel)


"Andrew" wrote in message
...
I am trying to get a formula to work for 3 different scenarios.

Cell R92 can have 3 outcomes:
- If the outcome is 0 the answer should be "Not Completed"
- If the outcome is 0 but =< than 1 the answer should be "Acceptable"
- if the outcome is than 1 the answer should be "Unacceptable"

I can not get an if formula to work.

Thank You
--
Andrew