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.

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


amey.gu...@gmail.com 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.

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

--

HTH

Bob Phillips

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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>