IF there is a # in a cell???
 

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

IF there is a # in a cell???
 

=IF(ISNUMBER(U5),R5,"")
--
David Biddulph

"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

IF there is a # in a cell???
 

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

IF there is a # in a cell???
 

=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

IF there is a # in a cell???
 

Another one:

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

--
Biff
Microsoft Excel MVP


"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