Return 0.00 if Neg.
I'm not sure, why you're using a SUM(D20-D19), but here is how you would use
a conditional formula.
=if(D20-D19<0,0.00,D20-D19)
"Canon" wrote:
Excel 2007
I am using a very simple formula;
cell D22=SUM(D20-D19)
But if the sum of the above formula is negative, I need to show 0.00 in cell
D22
|