Formula Problem

Guest · May 9, 2007

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

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

Guest · May 9, 2007

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

Guest · May 9, 2007

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

Perfect! Thank you so much.

Overtime Calculations	1	Apr 10, 2007
Formula Macro	6	Nov 9, 2006
Search	2	Jul 16, 2009
Formula confusion	3	Jul 12, 2004
Dynamic formula	1	Apr 19, 2010
Changing VBA code to paste values	0	May 9, 2017
Instead of a negative number, I'd like to show zero...	6	Dec 7, 2005
Negative Dates and/or Times	3	Mar 9, 2009

Ask a Question