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