greater than, less than, and in between

  • Thread starter Thread starter Dena
  • Start date Start date
D

Dena

Hi! Thanks in advance for the help! I am attempting to make a snapshot of a
report and I am having problems with a simple formula. In cells A1 and A2 I
have a formula that determines a percentage and then a conditional format
based on what the answer is-no problem with this part. Then in cells B1 and
B2 I want to look at the answer in the cell above and get one of these
answers greater than 100% HIGH, between 100% and 94% WARNING and anything
below 94% GOOD then I also have a conditional format this is color coded
based on that answer. My problem is on some of the answers I get a false
value return. Here is the formula I am using
=IF(C6>100%,"HIGH",IF(C6>=95%,"WARNING",IF(C6<=94%,"GOOD")))
I also tried
=IF(c6>100%,"HIGH",IF(C6<=100>=95%,WARNING",IF(C6<=94%,"GOOD")))
as well as many others. I know it is just me and I am not thinking over the
formula clear enough or should I take my decimals out further.
 
You would get "False" on values between 94 and 95. Try this:

=IF(C6>100%,"HIGH",IF(C6>=95%,"WARNING","GOOD"))

Tom
 
Let's reduce your question to its bare essentials:
In C6 you have a number;
In another cell you have
=IF(C6>100%,"HIGH",IF(C6>=95%,"WARNING",IF(C6<=94%,"GOOD")))

This works for me.
What do you mean by "false result"?
Give us some examples of the value in C6 and the result of the formula
Then tell use what you want to happen
best wishes
 
You don't need the third condition (<=94% will cover everything
else...assuming C6 does have a value and not #N/A)
Try
=IF(C6>100%,"HIGH",IF(C6>=95%,"WARNING","GOOD"))

btw which values are giving you a problem...
 
Back
Top