Excel Cell Reference; '=+' meaning

Closed
Nick - Mar 17, 2010 at 12:53 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2010 at 09:27 AM
Hello friends here,

I wish to ask a question about Excel cell referencing cell value from another work sheet.

1. The value in the cell was like this:
=+'Sheet2'!B3

2. In fact, Sheet2 stores a Query Table that has its values returned from the SQL Server Database.

3. And my problem is: I change the value on the cell to:
='Sheet3'!B3
or even ='Sheet2'!B3, without that "+" character,
and the value fail with literally "='Sheet2'!B3", not the value it is expected to get reference.


Could you possibly tell me what's the meaning of "=+" and how to use it correctly?
Thank you very much!

Nick.
Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 17, 2010 at 09:27 AM
From what I know

=+sheet1!a1 is nothing but +1 * sheet1!a1

Hard to tell you why it is failing without seeing the way that cell is being used
0