need if then statement help please
 

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
--
Thanks!

need if then statement help please
 

You could try:-

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

Mike


"learningaccess" wrote:

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
--
Thanks!

need if then statement help please
 

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


"Mike H" wrote:

You could try:-

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

Mike


"learningaccess" wrote:

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
--
Thanks!