Check if Number in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

amey.gupte@gmail.com - 24 Oct 2006 21:57 GMT

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.

Reply to this Message

Ken Puls - 24 Oct 2006 22:04 GMT

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

> Hi,
> In MS Excel, I want to check if the value in the cell above a cell is
[quoted text clipped - 9 lines]
> Mays Business School
> Texas A&M University.

Reply to this Message