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: urgent Excel question please???
From:	"Yakymakha L. Olexandr" <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Mon, 22 Apr 2002 10:12:28 +0300
Content-Type:	text/plain
Parts/Attachments:	text/plain (38 lines)

Hello Goran,

Sunday, April 21, 2002, 7:43:29 PM, you wrote:

GH> Mick,


GH> I am not an Excel wizard, however I experimented with the formulas for a
GH> while, and came up with the following:

So do I.
GH> Suppose you put people's names in column A.
GH> Suppose you put people's wights in column B.
GH> Put the default weight 90 kg in e.g. cell B1.

I don't know how to use the default value in Excel 97.
In Access this can be easy done. Try to explain in detail.

GH> In cell B2 write the formula: =IF(ISBLANK(A2);0;$B$1)
GH> It should be read "if the cell in column A (in the same row) is blank,
GH> return 0, else return the value in cell B1, i.e. 90 kg". Important: The
GH> dollar signs means an absolute cell reference.

Sorry, but this formula   =IF(ISBLANK(A2);0;$B$1) doesn't work in
Excel 97 (?).





--
Best regards,
 Yakymakha

             PCSOFT maintains many useful files for download
                     visit our download web page at:
                  http://freepctech.com/downloads.shtml

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG