How to get a reference to an adjacent cell (on the right) in libre?

Question

excel

You need to find out the difference between the sums of cells b3 and b2, but without specifying the exact addresses of the cells.

You need something like: Give me a link to the content of cell b3 to the right of cell C3 and then subtract from the content of b3 what is contained in the cell above b2.

Cell c3 should contain the result of the calculation: 52345100 - 48500000

Answer 1

The INDIRECT function allows you to point to a cell spaced a few cells up, down, right, left.

Answer 2

The maximum you can count on is offset