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.