Question description:
This user has given permission to use the problem statement for this
blog.
HI GOOD DAY I NEED FORMULA ON EXCEL IF A IS 2499 B IS 20% AND IF A IS 2501 THEN B IS 30% HOW TO WRITE FORMULA FOR THIS
Solved by B. S. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
06/07/2018 - 10:09
Hi there!
User
06/07/2018 - 10:09
HELLO
Excelchat Expert
06/07/2018 - 10:09
You've explained your desired logic perfectly.
Excelchat Expert
06/07/2018 - 10:09
I will program the formula and you can test it on your end.
User
06/07/2018 - 10:09
THANKS
Excelchat Expert
06/07/2018 - 10:10
One question I had - what if cell A1 is NEITHER 2499 or 2501? Or will it always be one of those 2 numbers?
User
06/07/2018 - 10:10
YES THERE WILL BE NUMBER IS CELL A
Excelchat Expert
06/07/2018 - 10:11
What if the number is NOT 2499 or 2501? What do you want B1 to say?
Excelchat Expert
06/07/2018 - 10:11
ah that is the desired result what you've entered in the google sheet?
User
06/07/2018 - 10:11
THERE WILL BE NUMBER
User
06/07/2018 - 10:12
EITHER GREATER THAN 2500
User
06/07/2018 - 10:12
OR LESSTHAN 2500
Excelchat Expert
06/07/2018 - 10:12
Perfect. And if it's greater than 2500, you want 30% of the number, and if it's less than 2500, you want 20%?
User
06/07/2018 - 10:12
YES
Excelchat Expert
06/07/2018 - 10:13
Ok perfect
Excelchat Expert
06/07/2018 - 10:13
what about if it's 2500 exactly
Excelchat Expert
06/07/2018 - 10:13
30% or 20%?
User
06/07/2018 - 10:13
30%
Excelchat Expert
06/07/2018 - 10:13
Thank you
Excelchat Expert
06/07/2018 - 10:14
=if(A1>=2500,A1*0.3,A1*0.2)
Excelchat Expert
06/07/2018 - 10:14
Give that a try!
Excelchat Expert
06/07/2018 - 10:18
Let me know if it works for you once you've tested!
User
06/07/2018 - 10:19
THANKS ITS WORKING
Excelchat Expert
06/07/2018 - 10:19
Yay!
Excelchat Expert
06/07/2018 - 10:20
My pleasure! Have a great day and please don'
Excelchat Expert
06/07/2018 - 10:20
t hesitate to reach back out to us with a new session if you need more assistance and we will be happy to help.
Excelchat Expert
06/07/2018 - 10:22
All the best to you! ~
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.