Forum Discussion
How to use IF formula to change cell value if below “value” but keeping additional formula
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,
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!
- You sir are amazing, you’re right it didn’t need the “ although I only added that as I thought “ defines the statement you’re making