Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I am trying to use multiple "IF" statements with one cell and having an issue
Solved by E. S. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/12/2017 - 09:06
HI, It's pleasure to help you today:)
User 07/12/2017 - 09:07
I'm about to pull my hair out... having an issue with IF function
Excelchat Expert 07/12/2017 - 09:07
Please share me the details.
User 07/12/2017 - 09:07
Can I paste what I am trying to accomplish in the worksheet?
Excelchat Expert 07/12/2017 - 09:07
Sure
Excelchat Expert 07/12/2017 - 09:09
Ok. I refer the data in the preview.
Excelchat Expert 07/12/2017 - 09:09
Please let me know the cell to work on?
User 07/12/2017 - 09:09
sorry, lost the page
Excelchat Expert 07/12/2017 - 09:10
Please refresh the browser
Excelchat Expert 07/12/2017 - 09:10
You can view the preview again
User 07/12/2017 - 09:10
ok
User 07/12/2017 - 09:12
Maybe I should have wrote that over here?
Excelchat Expert 07/12/2017 - 09:12
What are the percentage off for the ranges?
Excelchat Expert 07/12/2017 - 09:13
and which cell i need to implement?
User 07/12/2017 - 09:13
10% for the first 25000
User 07/12/2017 - 09:13
20 for anything above 25000 to 40000
User 07/12/2017 - 09:13
25 for any remaining balance after 40000
Excelchat Expert 07/12/2017 - 09:13
ok
User 07/12/2017 - 09:14
I did row 2 with an IF statement but cant seem to get row 3
Excelchat Expert 07/12/2017 - 09:15
You are comparing with A4 cell for row 2?
Excelchat Expert 07/12/2017 - 09:15
And how about for row 3?
User 07/12/2017 - 09:16
no comparing A2 with A4
Excelchat Expert 07/12/2017 - 09:17
=IF(A4<=25000,A4,"25000")
User 07/12/2017 - 09:17
for example
User 07/12/2017 - 09:17
the volume is 55000 so the first 25000 is 10% disvcount
Excelchat Expert 07/12/2017 - 09:18
Ok. got it. I am working on it.
User 07/12/2017 - 09:18
then in A3 I want it to return a number that is 14999 or less if the number is less than 14999
User 07/12/2017 - 09:19
Then in row 4 the remaining balance left if over the volume in teal, if it's zero then return a aero
User 07/12/2017 - 09:19
zero
User 07/12/2017 - 09:19
omg, it's even hard to explain let alone create the formula
User 07/12/2017 - 09:19
LOL
User 07/12/2017 - 09:20
1st-25000 10% discount
Excelchat Expert 07/12/2017 - 09:20
10% is based on 25000 or original value of 55000?
User 07/12/2017 - 09:20
2nd - if the amount exceeds 25000 then either that amount at 20% or the 14999 at 20%
User 07/12/2017 - 09:20
yes
Excelchat Expert 07/12/2017 - 09:21
10% is based on 25000 or original value of 55000?
User 07/12/2017 - 09:21
yes
User 07/12/2017 - 09:22
10% of 25000
Excelchat Expert 07/12/2017 - 09:22
ok
Excelchat Expert 07/12/2017 - 09:24
>40000? 25% of ?
User 07/12/2017 - 09:24
For 14999, if the amount is less then it needs to come back with the remaining balance
User 07/12/2017 - 09:24
If the number in teal is greater than 40000 then it needs to calculate 25% discount on that remaining number
Excelchat Expert 07/12/2017 - 09:25
ok.
User 07/12/2017 - 09:25
but if there is no remaining balance it needs to come back as a zero
Excelchat Expert 07/12/2017 - 09:25
In this case it is =55000-45001
User 07/12/2017 - 09:25
yes, but not quite that simple
User 07/12/2017 - 09:26
if a balance then show that number, if no balance then show 0
User 07/12/2017 - 09:26
And that's the same with row A2
Excelchat Expert 07/12/2017 - 09:28
Please test till A3 cell by changing the number in A1 cell?
Excelchat Expert 07/12/2017 - 09:28
I am working on the last one meanwhile.
User 07/12/2017 - 09:29
k changed
User 07/12/2017 - 09:31
Formula doesn't work as cell A2 should come back with 25000 no matter what number you put in there
Excelchat Expert 07/12/2017 - 09:31
25000 of 10% = 2500?
User 07/12/2017 - 09:32
ohhh.... not trying to get 10% off the 25000
User 07/12/2017 - 09:32
can you see the entire stuff i pasted to the sheet?
User 07/12/2017 - 09:33
look down at the other example
Excelchat Expert 07/12/2017 - 09:33
ok
Excelchat Expert 07/12/2017 - 09:33
There is no % applied
User 07/12/2017 - 09:33
No, just trying to calculate the volume so then I can apply the discount to that volume
Excelchat Expert 07/12/2017 - 09:34
ok
User 07/12/2017 - 09:35
OHHHH I think you got it
Excelchat Expert 07/12/2017 - 09:38
Ok. I have updated the formulas.
Excelchat Expert 07/12/2017 - 09:38
Please copy the formulas
User 07/12/2017 - 09:38
You ROCK.... thank you
Excelchat Expert 07/12/2017 - 09:39
Thank you.
Excelchat Expert 07/12/2017 - 09:39
Have a great day ahead:)
Excelchat Expert 07/12/2017 - 09:39
Please visit Got It Pro for new queries.
User 07/12/2017 - 09:39
wait
User 07/12/2017 - 09:40
hello?
User 07/12/2017 - 09:40
NVM
Excelchat Expert 07/12/2017 - 09:41
HI,
Excelchat Expert 07/12/2017 - 09:41
I have verified it. Hope, they are inline with your requirement.

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

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc