+ Reply to Thread
Results 1 to 3 of 3

If cell contains text do one thing, if it contains number do another thing

  1. #1
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    If cell contains text do one thing, if it contains number do another thing

    Hey everybody,

    Say I got Cell B2 that is based off the value of cell A2, but I need a formula that if A2 contains a text then B2 will also contain the same text with no changes to B2, but if A2 contains a number then I would like to have cell B2 contain the same number but to add an additional number to it. For example: B2 = A2 + 1000

    Any help on this matter will be most appreciated

    Thanks

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: If cell contains text do one thing, if it contains number do another thing

    =if(isnumber(a2),a2+1000,a2)

  3. #3
    Valued Forum Contributor
    Join Date
    11-27-2013
    Location
    Brooklyn, NY
    MS-Off Ver
    Office 365
    Posts
    1,172

    Re: If cell contains text do one thing, if it contains number do another thing

    That was a really fast answer1 And it worked perfectly!
    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. if one cell equals one thing then ...
    By tarpitman111 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-16-2012, 06:49 AM
  2. Changing text from one thing to another
    By mthompson93 in forum Excel General
    Replies: 2
    Last Post: 06-14-2010, 10:00 AM
  3. More than one thing in a Cell
    By bear in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2007, 03:26 PM
  4. How to put the same thing in two different cell'c?
    By Artur in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-23-2005, 01:00 PM
  5. [SOLVED] Can I disable this automatic number advance thing?
    By Paul in forum Excel General
    Replies: 3
    Last Post: 01-11-2005, 01:06 PM

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