Return 0.00 if Neg.

[Canon]

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

 

[Luke M]

=MAX(0,SUM(D20-D19))

 

[Mike H]

Try

=MAX(0,D20-D19)

Mike

 

[Christopher Robin]

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)