# Excel - IF Function Problem - Expert Solution

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
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.
Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.