PC Review


Reply
Thread Tools Rate Thread

Check if number in Excel

 
 
amey.gupte@gmail.com
Guest
Posts: n/a
 
      24th Oct 2006
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 With Quote
 
 
 
 
bobbo
Guest
Posts: n/a
 
      24th Oct 2006
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.


 
Reply With Quote
 
Bob Phillips
Guest
Posts: n/a
 
      24th Oct 2006
=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.
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to get excel to check last 2 digits in a 4 digit number realtorpete Microsoft Excel Misc 3 4th Jan 2009 08:52 PM
Check if Number in Excel amey.gupte@gmail.com Microsoft Excel Discussion 1 24th Oct 2006 10:04 PM
How can I check for a duplicate number in a column in Excel? =?Utf-8?B?a2tpbm5lcg==?= Microsoft Excel Misc 2 24th Aug 2006 03:44 PM
How to check for and replace the largest number in excel =?Utf-8?B?TmF2aWdhdGlvbiBNYW4=?= Microsoft Excel Worksheet Functions 1 20th Mar 2006 01:55 AM
How to check Excel version number with .net? Alain \Mbuna\ Microsoft VB .NET 7 5th Jan 2006 04:30 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:31 AM.