Login Page - Create Account

Support Board


Date/Time: Mon, 06 May 2024 20:05:36 +0000



Post From: CLR VERSION SPREADSHEET: SEPERATE SHEET REFERENCING QUESTION

[2013-11-28 12:10:05]
enemyspy - Posts: 304
HI here is an example of the formula:

=IF(SHEET11!ID4.SG4.3>0,1,0)

Here is the issue:

If I use the formula on a separate sheet as seen above, it always returns a 0 value.

Whereas the identical formula placed on the the same sheet that contains the study reference returns both 1s and 0s and functions correctly. Is the referencing other sheets within the same spreadsheet supported yet?

thanks again for the help I have recieved in the past.