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