I have a rather frustrating problem that it seems others have had also but I have yet to find a solution that works.
I have simplified things below as I tend to give too much information.
Basicly I have one formula that looks at another and if the result of the first is 1 then the second returns "GREAT"
but if the result of the first is 2 then the second returns "BAD".
I have a formula that looks at the result of a formular on a different worksheet (in the same work book) and returns
a conditional result depending on the result of the first formula BUT its not working how it should?
I have two work books, one called Data.xls & the other called Results.xls.
Results.xls has a work sheet called 'Data_Grab' that uses formulas to pull specific data from Data.xls.
These formulas are fairly basic like =IF(ISBLANK([Data.xls]Track!$F$2),"",""&[Data.xls]Track!$F$2& "").
There is a second work sheet in Results.xls called 'Data_Sort' which does as its name suggests - it is meant
to take the data from the 'Data_Grab' using formulas to present it in certain ways.
It is this part that is not working.
Lets say the formula in Cell A1 of 'Data_Sort' grabs the number 1 from cell A1 of 'Data_Grab'...
Even the most basic formula like =IF(Data_Grab!A1=1,TRUE,FALSE) as it always shows FALSE when it should show TRUE.
Now if i manually type the number 1 in Cell A1 of 'Data_Grab then the formula works?
For what ever reason the formula in Data_Sort wont accept the result of the formula in Data_Grab??
I have tried creating a 'helper' column in Data_Grab and converting the value of A1 to text which didnt work
and I have tried converting the value to a number which also didnt work.
The only thing that worked was if I manually type in the number 1...
I can not find a way around this so any suggestions would be great as I can not procede any further, I am stumped.