Share via

Excel IF function help

Anonymous
2023-03-01T17:36:26+00:00

So I’m new to excel and this is probably a dumb question but I need help with this formula:

=IF(G7=0.96,"2%",IF(G7=0.97,"4%",IF(G7=0.98,"6%",IF(G7=0.99,"8%",IF(G7=1,"10%",IF(G7>1.05,"12%"))))))

I followed what another forum told me to do and I keep getting the error pop-up and it says the function isn’t right.

what I am trying to accomplish is getting the formula to equal the following guidelines:

Goal % score
0% 0%
96% 2%
97% 4%
98% 6%
99% 8%
100% 10%
105% + 12%

Any help would be appreciated! tyia

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2023-03-01T17:42:28+00:00

Hi Han222,

Greetings! Thank you for posting to Microsoft Community.

I added ,"" in your formula as circled below, feel free to share any update.

=IF(G7=0.96,"2%",IF(G7=0.97,"4%",IF(G7=0.98,"6%",IF(G7=0.99,"8%",IF(G7=1,"10%",IF(G7>1.05,"12%",""))))))

Image

You can also use ifs formula like this.

=ifs(G7=0.96,"2%",G7=0.97,"4%",G7=0.98,"6%",G7=0.99,"8%"G7=1,"10%",G7>1.05,"12%")

Image

Best Regards,

Snow Lu

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-01T17:52:13+00:00

    OMG that worked perfectly!

    Thank you so much for your quick response Snow Lu, I appreciate it so much!

    Hope you have a great day! 😊

    Was this answer helpful?

    0 comments