ExcelBanter - IF Statement

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Statement (https://www.excelbanter.com/excel-discussion-misc-queries/256522-if-statement.html)

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

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

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