**Question description:**

*This user has given permission to use the problem statement for this blog.*

Im trying to enter a percentage of a number for different scenarios. Example = if a1>= 254 *"10%","*5%"

Solved by C. B. in 9 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
31/07/2018 - 12:03

Hello, I understand that you would like to assign a percentage depending on the value of another cell, right?

User
31/07/2018 - 12:03

yes

Excelchat Expert
31/07/2018 - 12:04

I can help you with this. Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.

User
31/07/2018 - 12:04

ok

Excelchat Expert
31/07/2018 - 12:04

May I have the details please?

Excelchat Expert
31/07/2018 - 12:04

What are the different possible scenarios?

User
31/07/2018 - 12:07

say cell a1 is > than a number I want to enter into that cell either 10% if true or 5% if false

User
31/07/2018 - 12:07

as a formula

Excelchat Expert
31/07/2018 - 12:08

Alright, I'll be using 254 as a placeholder then.

User
31/07/2018 - 12:08

0k

Excelchat Expert
31/07/2018 - 12:08

Here's the formula:

Excelchat Expert
31/07/2018 - 12:08

=if(A1>254,10%,5%)

Excelchat Expert
31/07/2018 - 12:09

You can try it in the sheet to the right. Change the value of A1 to test it out.

User
31/07/2018 - 12:09

ok what Im trying to do is get the 10% or 5% value not true or false

Excelchat Expert
31/07/2018 - 12:10

10% of cell A1, right?

User
31/07/2018 - 12:10

yes

User
31/07/2018 - 12:10

if true

Excelchat Expert
31/07/2018 - 12:10

=if(A1>254,A1*10%,A1*5%)

Excelchat Expert
31/07/2018 - 12:10

Use this formula then.

User
31/07/2018 - 12:11

you da man

Excelchat Expert
31/07/2018 - 12:11

Glad to have helped!

Excelchat Expert
31/07/2018 - 12:11

You were very close with your formula. :)

Excelchat Expert
31/07/2018 - 12:11

Would there be anything else that I can help you with regards to the original question?

User
31/07/2018 - 12:12

no thank you very much

Excelchat Expert
31/07/2018 - 12:12

Alright, if you have no other questions regarding the original concern, I'd appreciate a 5-star rating and your feedback if you think I deserve it.

Excelchat Expert
31/07/2018 - 12:12

I'll be giving you high ratings as well so the other experts will know that you are a good client and should be taken care of.

Excelchat Expert
31/07/2018 - 12:12

Please do not forget to click the End Session button otherwise I'll be stuck here until the timer expires and be unable to help others. Thank you.