Hi there
I have numerous tabs in my Calc document, which are named 2022-23, 2023-24, etc. One cell in the latest tab must perform a calculation involving a number from the previous tab. I’ve inserted the following formula in the latest tab in the appropriate cell:
=B9-Sheet2022-23.M9
As you’ve guessed it, it doesn’t work. Can somebody please point me in the correct direction.
LO 7.5.2.2
Many thanks.
If you can’t remember the syntax, the easiest way is to type =B9- and then navigate to and click the cell; Calc will enter the correct form for you as shown in @schiavinatto answer
Only impure sheet names must be apostrophized in references.
Use clean names exclusively, and the related problems vanish.
d2022_23 is clean for example, and =B9 - $d2022_23.M9 works as expected.
Correct it this way
=B9-$'2022-23'.M9