Try this;
=IF(ISNUMBER(U5),R5,"")
HTH
John
"al619" wrote in message
...
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