ExcelBanter - Formula Problem

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

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

- - Formula Problem (https://www.excelbanter.com/excel-worksheet-functions/142141-formula-problem.html)

roxiemayfield

Formula Problem

=SUM(D14:F14)=IF(D14<=0,)

I would like the answer to display 0 instead of FALSE. How do I do that?
Thank you!

Duke Carey

Formula Problem

=--(SUM(D14:F14)=IF(D14<=0,))

"roxiemayfield" wrote:

=SUM(D14:F14)=IF(D14<=0,)

I would like the answer to display 0 instead of FALSE. How do I do that?
Thank you!

roxiemayfield

Formula Problem

"Duke Carey" wrote:

=--(SUM(D14:F14)=IF(D14<=0,))

"roxiemayfield" wrote:

=SUM(D14:F14)=IF(D14<=0,)

I would like the answer to display 0 instead of FALSE. How do I do that?
Thank you!

Perfect! Thank you so much.

All times are GMT +1. The time now is 02:12 AM.