Welcome Guest
Log In | Register )
You last visited December 7, 2016, 7:02 pm
All times shown are
Eastern Time (GMT-5:00)

More excel questions

Topic closed. 3 replies. Last post 11 years ago by lottaloot.

Page 1 of 1
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: April 25, 2006, 9:57 pm - IP Logged

Is there a way that you can use the isnumber function in order to give the number as a results instead of true or false???

 

L ttaL   T

    Thoth's avatar - binary
    Findlay, Ohio
    United States
    Member #4855
    May 28, 2004
    400 Posts
    Offline
    Posted: April 26, 2006, 11:23 am - IP Logged

    Hmm...suppose you have a number or text in cell A1.  A1 could also contain nothing.  You could try this:

    =IF(ISNUMBER(A1),A1,"")

    If A1 contains any number, excel will return that number.  If the cell A1 contains text or is blank it will return nothing (because of the double quotation marks, which is the "IF Not" part of the formula).  You could make it return whatever you wanted when there is no number in A1 by replacing the double quotation marks with a ref to another cell or by adding a word between the quotes.

    ~Probability=Odds in Motion~

      lottaloot's avatar - AvatarZ56
      Redford/MI
      United States
      Member #3396
      January 18, 2004
      4867 Posts
      Offline
      Posted: April 27, 2006, 10:12 am - IP Logged

      Thanks

      I'll try that.

      L ttaL   T

        lottaloot's avatar - AvatarZ56
        Redford/MI
        United States
        Member #3396
        January 18, 2004
        4867 Posts
        Offline
        Posted: April 27, 2006, 9:00 pm - IP Logged

        Worked perfectly!

         

        Thanks Thoth Wink

        L ttaL   T