Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How to ignore text (2000)

    I have attached a worksheet that we use for expense reporting.

    I need to create a formula in cell H10 under Mileage calculation that checks the contents of cell B10 to see if it is a number (Actual Mileage) or text (Anything other than a number). It the content of B10 is text the formula should do nothing and leave H10 Blank, but it if is a number it needs to multiply that number by .37 ($.37 / Mile) and display the amount in H10 to be totaled at the bottom of the column.

    I am not a programmer so please keep it as simple as possible.

    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: How to ignore text (2000)

    <pre>=IF(ISNUMBER(B10),B10*0.37,"")</pre>


    Steve

  3. #3
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: How to ignore text (2000)

    Steve,

    It works perfectly. Thanks.

    Thom

Posting Permissions

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