IF there is a # in a cell???

[al619]

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

 

[John]

Try this;
=IF(ISNUMBER(U5),R5,"")
HTH
John

 

[Gord Dibben]

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

Note: dates are numbers.


Gord Dibben MS Excel MVP

 

[T. Valko]

Another one:

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