Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Have negative numbers show as zero
=IF(X582="Closed",0,MAX(Networkdays(K582,Lists!N$1 ,Lists!P$2:P$45)-10,0) Hope this helps! Candee Wrote: Hello everyone. I currently have the following formula in a worksheet to determine the number of working days between the current date (Lists!N$1) and an Issued Date (K582) if the item is showing as Open, less the 10 allowable days for a response (days overdue greater than 10) and it is giving the desired results. =IF(X582="Closed",0,(Networkdays(K582,Lists!N$1,Li sts!P$2:P$45))-10) Except that if an item were issued yesterday, it returns a value of -8. I would like it to show "0" if it is a negative number, as that means that it is really not overdue at all. Can someone help me amend the formula that I already have or provide a possibly easier (more efficient) way to accomplish what I am trying to do? Thanks in advance, and I appreciate any and all responses. Have a great day!!! Candee -- Domenic ------------------------------------------------------------------------ Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785 View this thread: http://www.excelforum.com/showthread...hreadid=276653 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why cant you show negative numbers in parentheses? | Excel Discussion (Misc queries) | |||
Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
Negative numbers turn positive automatically on data entry | Excel Discussion (Misc queries) | |||
How do I display negative numbers in a differnt color font? | Excel Discussion (Misc queries) | |||
Negative Numbers | Excel Discussion (Misc queries) |