If statement

J

jen-chi

I trying to check is our performance is met on a monthly basis, we promise
the following:
95% target
Click to expand...
<95% & >90% below target
<90% unacceptable

I have the following forumala but cannot get the unacceptable to populate
when we are below the 90%

C6 = 95%
D6 = 90%
J6 = is our actual performance

=IF(I6=0," ",(IF(J6>=C6,"Target",IF(J6<C6&J6>D6,"Below
Target","Unacceptable"))))
 
G

Glenn

jen-chi said:
I trying to check is our performance is met on a monthly basis, we promise
the following:

<95% & >90% below target
<90% unacceptable

I have the following forumala but cannot get the unacceptable to populate
when we are below the 90%

C6 = 95%
D6 = 90%
J6 = is our actual performance

=IF(I6=0," ",(IF(J6>=C6,"Target",IF(J6<C6&J6>D6,"Below
Target","Unacceptable"))))
Click to expand...


=IF(I6=0," ",IF(J6>=C6,"Target",IF(J6>=D6,"Below Target","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

To combine various cell formulae in to the final cell 1
my first excel experience (share portfolio) 2
Formula Problem with IF (Negative and Positive Numbers) 2
if function error 3
Help Regarding UDF or VBA 1
Complicated IF statement - desperately need some help 4
conditional statement using validation cell 2
COUNTIF, only counting once if both cells contain the data 5

Top