Hi
The problem is that the =if formula used picks the cell with the )=RIGHT(D57, LEN(D57)-3) as a text string returned...or at least thats what I think ;)
But try adding the following to your formula and see if it present you with any diffirent results
repalce your formula with the following
=1*RIGHT(D57, LEN(D57)-3)
Maybe worth a try.
Quote:
Originally Posted by FreedomHillFarm
I created a column that strips the characters to leave a number (Eng1 becomes 1)=RIGHT(D57, LEN(D57)-3).
Then, in another column I use the function =if(f2=g2,"ID","OOD"). The function doesn't work at all. However, when I go into the cell that has the =RIGHT(D57, LEN(D57)-3) and replace it with a number... the if function =if(f2=g2,"ID","OOD") works perfectly.
Any suggestions?
Thanks for your time in helping with this...it's driving me nuts!
|