Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Strange
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! |
#2
|
|||
|
|||
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:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strange?! | Excel Discussion (Misc queries) | |||
Strange error | Setting up and Configuration of Excel | |||
Strange Problem | Excel Discussion (Misc queries) | |||
Very-2 strange | Excel Discussion (Misc queries) | |||
Something Strange | Setting up and Configuration of Excel |