Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
if statement | Excel Discussion (Misc queries) | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |