Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Excel 97 zero to replace minus
From:	Tom Turak <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 8 Oct 2003 16:05:34 -0400
Content-Type:	text/plain
Parts/Attachments:	text/plain (38 lines)

Your cell containing the total should have the formula

=MAX(0,SUM(B2:B10))

assuming you are summing a contiguous range of cells B2 to B10.

If you are summing an assortment of cells, just add the cells after the
comma.

=MAX(0,B12+B24+H12+H24)

You can have more than one comma if you need to compare several totals.
This also works

=MAX(0,D12+D24+D36,K12+K24+K36)

Tom Turak


-----Original Message-----
From: Mick Fitzpatrick [mailto:[log in to unmask]]
Sent: Wednesday, October 08, 2003 2:20 PM

I have a simple Excel 97 spreadsheet that adds up a few rows ... real basic
stuff

In the bottom box I show the total ... sometimes this can be a minus figure
and Excel 97 will display as    -33

What I would like to do is show zero for any minus total ... so rather than
display -33 it will display 0 but still display any totals over zero

TIA ... Mick

             Do you want to signoff PCSOFT or just change to
                    Digest mode - visit our web site:
                   http://freepctech.com/pcsoft.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG