slight correction
=IF(SUM(N8:N9)-SUM(N20:N21)=0,"",SUM(N8:N9)-SUM(N20:N21))
--
HTH
Bob Phillips
"Bob Phillips" wrote in message
...
=IF(SUM(N8:N9)-SUM(N20:N21)=0,"",SUM(N8:N9)-SUM(N20:N21))
--
HTH
Bob Phillips
"force530" wrote in message
...
=SUM(N8:N9)-SUM(N20:N21)
If the results from the above formula are 0 or less than 0, how can I
leave
the results blank or at 0?
|