# Excel - IF Function Problem - Expert Solution

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.

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.

## Click here to get your free Excelchat help session

Trusted by people who work at