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

Top