ExcelBanter - Strange

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Strange (https://www.excelbanter.com/excel-worksheet-functions/268023-strange.html)

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!

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 (Post 961942)