Announcement

Collapse
No announcement yet.

checking if a cell is numeric

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: checking if a cell is numeric

    Try...

    =ISNUMBER(A1)

    Hope this helps!

    Comment


    • #3
      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

      Comment


      • #4
        Re: checking if a cell is numeric

        Code:
        =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?

        Comment


        • #5
          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.
          Kris

          ExcelFox

          Comment


          • #6


            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!

            Comment

            Working...
            X