Forum Discussion
How to use IF formula to change cell value if below “value” but keeping additional formula
I am working on a test document to learn excel, below is my problem.
What I am wanting to do is make Cell D6 show “0” if Cell C6 is below 11500 but if Cell C6 isn’t below 11500 then Cell D6 to continue working with its formula at calculating tax at 20%.
Hope you can all help guys :)
Hi Lee,
My formula in the previous reply is this:
=IF(C6<11500,0,SUM(C6-F14)*D14)
But your formula in the cell D6 is this:
=IF(C6<11500,"0","SUM(C6-F14)*D14")
Please compare them and note the difference!
I don't know why you put the double quotes around the zero and the SUM formula!
Double quotation marks disable any calculation, and converts it to text!
Thank you for your input, however it totally effects the cell and does not comprehend your suggestion. Attached in a picture of my current formula.
D6 formula needs to remain the same as it works with C6 so I guess I need to add an additional formula into D6?
Hi Lee,
If so, please try this instead:
=IF(C6<11500,0,SUM(C6-F14)*D14)
Hope that helps
As you can see when C6 value dropped below 11500 it gives us the "0" in D6 in which I wanted, however, as you can see in the second picture when C6 value goes above 11500 it displays the formula in D6 rather than the actual calculation I'm after.
I apologise for the complexity but feel like you'll be able to get me there in the end :)
Hi Lee,
Please start in cell D6 then put this formula in it:
=IF(C6<11500,0,C6*20%)
