Change Negative Numbers to 0

's Computer Specifications

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.

's Computer Specifications

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." <(E-Mail Removed)> wrote in message
news:52A2A800-671C-455D-9470-(E-Mail Removed)...
>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.

's Computer Specifications

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." <(E-Mail Removed)> wrote in message
> news:52A2A800-671C-455D-9470-(E-Mail Removed)...
> >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.
>

's Computer Specifications

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

's Computer Specifications

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

's Computer Specifications

> =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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
> =----

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to change positive numbers to negative numbers without re-ente	=?Utf-8?B?OTU0MW1vb3NlZ2lybA==?=	Microsoft Excel Worksheet Functions	8	5th Mar 2008 05:35 PM
Excel, change column of negative numbers to positive numbers?	Nita	Microsoft Excel New Users	3	27th Nov 2007 04:54 AM
change 2000 cells (negative numbers) into positive numbers	=?Utf-8?B?bGlzYmVybg==?=	Microsoft Excel Worksheet Functions	2	16th Aug 2006 05:54 PM
How to change a series of positive numbers to negative numbers	=?Utf-8?B?RWxsaWU=?=	Microsoft Excel Worksheet Functions	5	5th Sep 2005 05:10 PM
Change positive numbers (debits) to negative numbers (credits)	=?Utf-8?B?Q2FybGEgR2lsbGVzcw==?=	Microsoft Access VBA Modules	4	17th Dec 2004 06:50 PM