Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
The statement below is working good. I need to add a statement to the end
that all other numbers will be 200%. Can someone help, please. =(IF(G6=20,"110%",(IF(G6=25,"110%",(IF(G6=50,"110% ") Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
Tina
Try this nut note a couple of things, There are no a lot less parenthesis, yo had too many Ive removed the quites from the percent answers. Format your formula cell as percent with as many or as few decimal places as you want If the formula works for you then that's fine but it 'could' produce unwanted results. For example a value of 21 previously evaluated to FALSE and will now evaluate as 200%. If this isn't acceptable then post back. =IF(G6=20,110%,IF(G6=25,110%,IF(G6=50,110%,200%))) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Tina" wrote: The statement below is working good. I need to add a statement to the end that all other numbers will be 200%. Can someone help, please. =(IF(G6=20,"110%",(IF(G6=25,"110%",(IF(G6=50,"110% ") Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Statement
Mike
Thank you so much!! This worked perfectly. "Mike H" wrote: Tina Try this nut note a couple of things, There are no a lot less parenthesis, yo had too many Ive removed the quites from the percent answers. Format your formula cell as percent with as many or as few decimal places as you want If the formula works for you then that's fine but it 'could' produce unwanted results. For example a value of 21 previously evaluated to FALSE and will now evaluate as 200%. If this isn't acceptable then post back. =IF(G6=20,110%,IF(G6=25,110%,IF(G6=50,110%,200%))) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Tina" wrote: The statement below is working good. I need to add a statement to the end that all other numbers will be 200%. Can someone help, please. =(IF(G6=20,"110%",(IF(G6=25,"110%",(IF(G6=50,"110% ") Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
If statement or lookup statement not sure | Excel Worksheet Functions | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |