Calculating cell numbers in the name

[AleksitjVladica]

How to get cell A2-1, no brackets or things I tried work. This is an example.

[karolus]

Hallo

=OFFSET(A2;-1;0)  #this is an example

[LeroyG]

If A2 content is 5, do you need your calculus to show 4, or the value in A1?
In the first case just add a “=” sign before the formula; in the second, see @karolus comment.

[AleksitjVladica]

The second case it is.
Thank you.

[AleksitjVladica]

Thank you.