Check if number in Excel
 

Hi,
In MS Excel, I want to check if the value in the cell above a cell is
numeric. For eg
I want a formula in Cell D8 if value in Cell D7 is numeric. How do I do
it.

Thank You.

Sincerely,
Amey Gupte
MS in Management Information Systems
Mays Business School
Texas A&M University.

Check if number in Excel
 

in a worksheetfunction the function would be isnumber(). In vba the
function is isnumeric().
They both return true or false depending on whether the data is a
number


wrote:
Hi,
In MS Excel, I want to check if the value in the cell above a cell is
numeric. For eg
I want a formula in Cell D8 if value in Cell D7 is numeric. How do I do
it.

Thank You.

Sincerely,
Amey Gupte
MS in Management Information Systems
Mays Business School
Texas A&M University.

Check if number in Excel
 

=IF(ISNUMBER(D7),"Yes","No")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

wrote in message
ups.com...
Hi,
In MS Excel, I want to check if the value in the cell above a cell is
numeric. For eg
I want a formula in Cell D8 if value in Cell D7 is numeric. How do I do
it.

Thank You.

Sincerely,
Amey Gupte
MS in Management Information Systems
Mays Business School
Texas A&M University.