Check if Number in Excel

[amey.gupte]

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.

 

[Ken Puls]

You need an IF statement in D8 to check if the cell in D7 contains a
numeric value. Replace "Is a Number" with the formula you want there
(no = sign), and replace "Not a number" with what you want to happen if
not a number in D7. (Could be "" for blank, or 0, etc...)

=IF(ISNUMBER(D7),"Is a number","Not a number")

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca