L Luis Apr 27, 2009 #1 In the formula =If (02="carports,"'input data' ! $B*X2*1000,"ERROR" What does the ! stand for in Formula
In the formula =If (02="carports,"'input data' ! $B*X2*1000,"ERROR" What does the ! stand for in Formula
A AltaEgo Apr 28, 2009 #2 It is a separator between the sheet name and the cell address... and I suspect your formula should look like this: =IF(O2="carports",'input data'!$BX2*1000,"ERROR")
It is a separator between the sheet name and the cell address... and I suspect your formula should look like this: =IF(O2="carports",'input data'!$BX2*1000,"ERROR")
