+ Reply to Thread
Results 1 to 3 of 3

Ignore Text for Formula

  1. #1
    Registered User
    Join Date
    07-12-2005
    Location
    Brisbane, Australia
    Posts
    21

    Ignore Text for Formula

    I've got a cell that will either produce a numeric vakue as the answer or subject to an If Statement will produce nothing ie "". I'm using "" rather than 0 as I don't want it to be visable unless it's a number.

    My problem is that I want to use the answer from this cell in further calcs. The calc is just adding two cells ... but if the answer to the cell has text then just ignore it and produce the value in the first cell.

    Eg. A1 + A2 = X
    Where A2 = Text then = A1


  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,525

    Red face

    Eg. A1 + A2 = X
    Where A2 = Text then = A1

    =if(A2="",A1,A1+A2)

  3. #3
    Registered User
    Join Date
    07-12-2005
    Location
    Brisbane, Australia
    Posts
    21

    Thumbs up

    Thanks Dave ... appreciated

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1