Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: checking if a cell is numeric

  1. #1
    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. #2
    Join Date
    4th July 2004
    Location
    Canada
    Posts
    2,300

    Re: checking if a cell is numeric

    Try...

    =ISNUMBER(A1)

    Hope this helps!

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    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. #4
    Join Date
    2nd April 2003
    Location
    Victoria, Australia
    Posts
    90

    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
    If absence makes the heart grow fonder, and familiarity breeds contempt, perhaps my wife should live in Darwin?

  5. #5
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,366

    Re: checking if a cell is numeric

    Hi,

    =If(ISNUMBER(A1)=True,Your Formula Here,Do Nothing)
    You don't need an additional True.

    =If(ISNUMBER(A1),Your Formula Here,Do Nothing) suffice.

  6. #6
    Join Date
    4th July 2004
    Location
    Canada
    Posts
    2,300

    Re: checking if a cell is numeric

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

    Hope this helps!

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 18
    Last Post: February 28th, 2007, 23:20
  2. Checking Cell Value is a Number
    By choff in forum EXCEL HELP
    Replies: 6
    Last Post: August 7th, 2006, 03:24
  3. Checking for a number in a cell
    By Diego_Garcia in forum EXCEL HELP
    Replies: 3
    Last Post: February 7th, 2005, 06:34
  4. Checking if the cell is blank
    By haresh_herwani in forum EXCEL HELP
    Replies: 2
    Last Post: May 6th, 2004, 04:34

Bookmarks

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