ExcelBanter - Help on this formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help on this formula (https://www.excelbanter.com/excel-worksheet-functions/33499-help-formula.html)

force530

Help on this formula

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

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

Niek Otten

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

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

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

Bob Phillips

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?

All times are GMT +1. The time now is 09:45 AM.