If function

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

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
 
Try this...

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