I have a problem with this formula :
=IF($F$5='\\S154-0106\Data\Personeel\Uurroosters\2012\[Uurrooster 2012.xls]JAN'!$E$25;1,1;0). This formula returns the value '1,1'
Deze formule werkt perfect.
Now I want to assemble the cell reference myself, something like this :
=IF($F$5="'\\S154-0106\Data\Personeel\Uurroosters\2012\[Uurrooster 2012.xls]JAN'!$E$"&P1;1,1;0)
Value of P1 is 25.
I would expect that the result of this formula would return '1,1' as well, but instead it returns '0'
When I try this formula: ="'\\S154-0106\Data\Personeel\Uurroosters\2012\[Uurrooster 2012.xls]JAN'!$E$"&P1 it return the following value :: '\\S154-0106\Data\Personeel\Uurroosters\2012\[Uurrooster 2012.xls]JAN'!$E$25 instead of the value of this cell.
Has it something to do with the brackets ? Anyone ideas ?
Thanx
Bookmarks