If function

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
 
R

Rick Rothstein

Try this...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Transfer data between two tables 3
Subtracting two cell dates and highlight if over due by a certain amount of days 0
True false function for alpha data 7
Calculating probabilities 16
Clearing combo boxes and a text box 2
Mail Merge Problem 1
Formula Help Needed . . 11

Top