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:	[log in to unmask]
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Wed, 8 Oct 2003 15:15:20 -0400
Content-Type:	text/plain
Parts/Attachments:	text/plain (31 lines)

Try something like this. You will need to adjust your formula.

=If(h60/30>0,h60/30,0)


If you need more help respond back.
Good Luck
Richard F. Bolha

On 8 Oct 2003 at 19:19, Mick Fitzpatrick wrote:

> Hello
>
> 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
>
> Is it possible to do this?
>
> I hope I have made myself clear
>

              The NOSPIN Group is now offering Free PC Tech
                     support at our newest website:
                          http://freepctech.com

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG