Negative Nos

Dear All,

I've got a file with sum formulas and datas as well,i need to know
when ever i'm getting a negative no as result, it should be zero
or the cell should be empty.

Thanks in Advance,
Aks

How about: =MAX(0;formula)

hello,

Please find the attached file,C4 is giving a negative value and C6 is giving a positive value
actually my requirement is when A4 or B4 is missing the end result should be zero rather
than getting a positive or negative values.

Thanks in Advance,
Aks

...actually my requirement is when A4 or B4 is missing the end result should be zero rather
than getting a positive or negative values

in which case:

C4: =IF(COUNT(A4:B4)<2,0,MAX(0,B4-A4))
copied down

or if you're saying negative values now permitted

C4: =IF(COUNT(A4:B4)<2,0,B4-A4)
copied down