=IF(ISNUMBER(U5),R5,"")

Note: dates are numbers.


Gord Dibben MS Excel MVP

On Tue, 16 Dec 2008 16:31:01 -0800, al619
wrote:

What is the symbol in a formula that will generalize any number.
Example:
=IF(U5="#",R5,"")
# - Not sure if this is the correct symbol for "any number"
Thanks for any help,
al619