Show Zeros


F

Frank

I have the following formula in a cell, however I am
running this for a whole year and the cells in the future
months of the year show a negative number. Where can I
show a zero if the number is a negative.

=IF(($B$31-W1)>=W4,F21,(NETWORKDAYS(W1,$B$31)*F21/W3))

Thanks
Frank
 
Ad

Advertisements

K

Ken Wright

Try =MAX(0,Your_Formula) eg:-

=MAX(0,IF(($B$31-W1)>=W4,F21,(NETWORKDAYS(W1,$B$31)*F21/W3)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zeros Not Showing 4
Show zero 2
Show zero values 4
Showing Zero amounts 2
Show leading zeros. 6
showing zero in cell 5
show zero as dash 2
Format that shows Zero 3

Top