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
|