Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Negative Numbers to 0
I have a cell that calculates how many business days between two dates
=NETWORKDAYS(B3,C1). If that formula produces a negative number I would like the value of the cell to be 0 "zero". Any suggestions? -- Sherry N. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Negative Numbers to 0
Sherry,
Try =MAX(0,NETWORKDAYS(B3,C1)) -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Sherry N." wrote in message ... I have a cell that calculates how many business days between two dates =NETWORKDAYS(B3,C1). If that formula produces a negative number I would like the value of the cell to be 0 "zero". Any suggestions? -- Sherry N. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Negative Numbers to 0
Perfect! Thanks so much!
-- Sherry N. "Chip Pearson" wrote: Sherry, Try =MAX(0,NETWORKDAYS(B3,C1)) -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "Sherry N." wrote in message ... I have a cell that calculates how many business days between two dates =NETWORKDAYS(B3,C1). If that formula produces a negative number I would like the value of the cell to be 0 "zero". Any suggestions? -- Sherry N. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Negative Numbers to 0
=max(NETWORKDAYS(B3,C1),0)
-- Regards, Tom Ogilvy "Sherry N." wrote: I have a cell that calculates how many business days between two dates =NETWORKDAYS(B3,C1). If that formula produces a negative number I would like the value of the cell to be 0 "zero". Any suggestions? -- Sherry N. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Negative Numbers to 0
How about
=IF(NETWORKDAYS(B3,C1)<0,0,NETWORKDAYS(B3,C1)) D-C Sherry wrote: I have a cell that calculates how many business days between two dates =NETWORKDAYS(B3,C1). If that formula produces a negative number I would like the value of the cell to be 0 "zero". Any suggestions? ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Negative Numbers to 0
=IF(NETWORKDAYS(B3,C1)<0,0,NETWORKDAYS(B3,C1))
In most cases, that would call NETWORKDAYS twice, adding unnecessary overhead to the calculations. "Dave D-C" wrote in message ... How about =IF(NETWORKDAYS(B3,C1)<0,0,NETWORKDAYS(B3,C1)) D-C Sherry wrote: I have a cell that calculates how many business days between two dates =NETWORKDAYS(B3,C1). If that formula produces a negative number I would like the value of the cell to be 0 "zero". Any suggestions? ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change positive numbers to negative numbers without re-ente | Excel Worksheet Functions | |||
Excel, change column of negative numbers to positive numbers? | New Users to Excel | |||
CHANGE A ROW OF POSTIVE NUMBERS TO NEGATIVE NUMBERS | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
How to change a series of positive numbers to negative numbers | Excel Worksheet Functions |