Forum Discussion
Solved
How to use IF formula to change cell value if below “value” but keeping additional formula
Hi forum, 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 Ce...
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!
Hi Lee,
Please start in cell D6 then put this formula in it:
=IF(C6<11500,0,C6*20%)