Help on this formula

[Guest]

=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?

 

[Bob Phillips]

=IF(SUM(N8:N9)-SUM(N20:N21)=0,"",SUM(N8:N9)-SUM(N20:N21))

 

[Niek Otten]

=MAX(SUM(N8:N9)-SUM(N20:N21),0)

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

 

[Bob Phillips]

slight correction

=IF(SUM(N8:N9)-SUM(N20:N21)=>0,"",SUM(N8:N9)-SUM(N20:N21))