Maybe

=IF(R921,"Unacceptable",IF(R920,"Acceptable","No t Completed"))

Mike

"Andrew" wrote:

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