need if then statement help please

[Guest]

Hi,

I'm trying to put a formula in excel to do the following. I'm getting a
percentage of revenue over budget. Then I am trying to say if value is >=
100% then "Over 100%", if value is >=80 % and <100% then "Over 80%, Under
100%" and if value is <80% then "Under 80%". The over 100% and Under 80% are
working. Can't get the middle criteria to work.
this is my formula so far:
=IF(F7>=1,"Over 100%",IF(F7>=0.8<1,"Over 80%, Under 100%",IF(F7<0.8,"Under
80%",0)))

I can get text to say "Over 100%" and also to say "Under 80%". But the
"Over 80%, Under 100%" text is returning as 0.

Please help with formula.
Thank you so much.

Chris

 

[Guest]

You could try:-

=IF(F7>=1,"Over 100%",IF(F7>=0.8,"Over 80%, Under 100%","Under 80%"))

Mike

 

[Guest]

Thank you.. I modified yours a bit. Didn't expect the logic to work that
way.
Thanks again and have a great day.
Chris