+ Reply to Thread
Results 1 to 4 of 4

IF formula not working because cell has a formula in it (IF and LEFT FORMULA)

  1. #1
    Forum Contributor
    Join Date
    01-15-2015
    Location
    New York
    MS-Off Ver
    Excel 2011 MAC
    Posts
    104

    IF formula not working because cell has a formula in it (IF and LEFT FORMULA)

    I'm trying to pull the first three letters from a cell, and then with that use an IF formula. I was able to successfully pull the first three letters out, but when I use an IF formula in another cell it's giving me the false value, even when it's true.
    I'm assuming because the cell I'm referencing is from a formula. I could put the two formulas together, but I wasn't sure how to blend them into one.

    In column D, I need to use 25 for PT, 40 for FT and 15 for LPT.

    in D1 it should say 25, but it's pulling the false of 40.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: IF formula not working because cell has a formula in it (IF and LEFT FORMULA)

    You're pulling the first 3 characters, which includes a space at the end. You can use:

    =TRIM(LEFT(F1,3))

    to remove the unnecessary space.
    Rory

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: IF formula not working because cell has a formula in it (IF and LEFT FORMULA)

    Formula in E1 is =LEFT(F1,2), not =LEFT(F1,3)

  4. #4
    Forum Contributor
    Join Date
    01-15-2015
    Location
    New York
    MS-Off Ver
    Excel 2011 MAC
    Posts
    104

    Re: IF formula not working because cell has a formula in it (IF and LEFT FORMULA)

    Oh, thank you so much!

+ 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. [SOLVED] How to stop a date formula from working if original cell is left blank
    By Mr.Bean in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-06-2017, 01:53 PM
  2. [SOLVED] Left() and Right() Formula in one cell
    By hack4u in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2016, 09:51 AM
  3. [SOLVED] formula to reference cell on the left and add +1
    By kris_ in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 10-04-2015, 12:54 PM
  4. [SOLVED] Need help with formula not working only show the formula in cell
    By Masekind in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-06-2014, 08:30 AM
  5. [SOLVED] Using Countif formula on cells that have a Left formula
    By fsoares22 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-10-2013, 11:13 AM
  6. Formula for cell=exact(left...&2)
    By nastech in forum Excel General
    Replies: 6
    Last Post: 06-10-2006, 07:00 AM
  7. LEFT &RIGHT formula on the same cell
    By Bonnie W. in forum Excel General
    Replies: 5
    Last Post: 02-09-2006, 12:35 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