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.
Bookmarks