On Jan 15, 5:10*pm, Pete_UK wrote:
I have Excel 2000 and can find the functions directly in XL Help.
However, in both descriptions the following sentence appears:
"... This function is provided for compatibility with other spreadsheet
programs. ..."
so perhaps they are destined to be left out sometime in the future.

Yup, that certainly adds to my speculation <sigh. I wonder if these
functions are in Excel 2007.

It would be too bad to see N() disappear. (Hmm, can we "see"
something disappear? <g) I like to use it as sure-fire way to handle
what appears to be an empty cell (might be truly empty or "" or " ")
as well as a zero value or text. 'Spose I could resort to using
SUM(A1), as we see so many people doing "needlessly" <wink.