Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: checking if a cell is numeric

1. Member
Join Date
29th January 2005
Posts
85

## checking if a cell is numeric

hi all

i was wondering if there is a function to check if the cell contains any numeric number? is it something like isnum?

thanks

stan

Excel Video Tutorials / Excel Dashboards Reports

2. Super Moderator
Join Date
4th July 2004
Location
Posts
2,371

## Re: checking if a cell is numeric

Try...

=ISNUMBER(A1)

Hope this helps!

Excel Video Tutorials / Excel Dashboards Reports

3. Member
Join Date
29th January 2005
Posts
85

## Re: checking if a cell is numeric

HI Domenic,

if i wanna check if the cell is a number and then proceed on to another function,

is the formula =IF(ISNUMBER(A1)='TRUE',YES.TRYAGAIN)

Stan

Excel Video Tutorials / Excel Dashboards Reports

4. ## Re: checking if a cell is numeric

VB:
```=If(ISNUMBER(A1)=True,Your Formula Here,Do Nothing)

```
If A1 contains a number, your formula is processes, otherwise nothing happens.

HTH

Richard

5. Super Moderator
Join Date
18th November 2004
Location
God's Own Country
Posts
4,477

## Re: checking if a cell is numeric

Hi,

You don't need an additional True.

6. Super Moderator
Join Date
4th July 2004
Location
Posts
2,371

## Re: checking if a cell is numeric

Originally Posted by gazzapoh
=IF(ISNUMBER(A1)='TRUE',YES.TRYAGAIN)
=IF(ISNUMBER(A1),"YES","TRYAGAIN")

Hope this helps!

Excel Video Tutorials / Excel Dashboards Reports

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno