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.