Results 1 to 5 of 5

Adding another true_value to an IF Formula

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-01-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    280

    Adding another true_value to an IF Formula

    Hello all,
    Im trying to add another true_value onto this following formula:

    =IF(OR(RIGHT(A2,5)={"396OL","400OL"}),"101OL",RIGHT(A2,5))

    I have attached a sample workbook. On the left side is my current formula and on the right will be result I'd like to achieve.

    My current formula will do the following
    396OL will convert to 101OL
    400OL will convert to 101OL
    If false then keep the last 5 values from the original code.

    But Id like to place in the following true_value:
    If 413OL then convert to 103OL NOT 101OL
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 08-06-2018, 07:54 AM
  2. Adding Hyperlink formula to existing formula
    By Shawna11 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-18-2018, 01:46 PM
  3. Adding a Date Formula to existing formula
    By bdav1216 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2016, 08:21 PM
  4. [SOLVED] Formula for adding a percentage from one cell and adding the total of 2 others
    By Kandra in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-04-2013, 06:48 AM
  5. adding Indirect formula to my current sum if array formula
    By Eastbay2 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-13-2013, 09:41 AM
  6. Replies: 1
    Last Post: 02-24-2013, 06:27 PM
  7. Replies: 8
    Last Post: 03-21-2012, 12:04 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