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.
