If function
 

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

If function
 

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

If function
 

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

If function
 

Thank You very much!!!
--
Andrew


"Rick Rothstein" wrote:

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