**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.*