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:	Peter Shkabara <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 8 Oct 2003 12:44:43 -0700
Content-Type:	text/plain
Parts/Attachments:	text/plain (27 lines)

This is easy to do. The code would look something like this:

IFF(SUM(E5:E15)<0,0,SUM(E5:E15))

Peter
-----------------------------------------------
The NoSpin Group
[log in to unmask]

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