greater than, less than, and in between
 

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(C6100%,"HIGH",IF(C6=95%,"WARNING",IF(C6<=94% ,"GOOD")))
I also tried
=IF(c6100%,"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.

greater than, less than, and in between
 

You would get "False" on values between 94 and 95. Try this:

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

Tom

greater than, less than, and in between
 

Let's reduce your question to its bare essentials:
In C6 you have a number;
In another cell you have
=IF(C6100%,"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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Dena" wrote in message
...
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(C6100%,"HIGH",IF(C6=95%,"WARNING",IF(C6<=94% ,"GOOD")))
I also tried
=IF(c6100%,"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.

greater than, less than, and in between
 

You don't need the third condition (<=94% will cover everything
else...assuming C6 does have a value and not #N/A)
Try
=IF(C6100%,"HIGH",IF(C6=95%,"WARNING","GOOD"))

btw which values are giving you a problem...
"Dena" wrote:

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(C6100%,"HIGH",IF(C6=95%,"WARNING",IF(C6<=94% ,"GOOD")))
I also tried
=IF(c6100%,"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.

greater than, less than, and in between
 

Thanks it worked!!!!!.

"TomPl" wrote:

You would get "False" on values between 94 and 95. Try this:

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

Tom