How to access the current cell?

Question

Google Apps Script

You need to get a pointer to the cell that is equal to the result of the function. For example, the function returns the sum of the values ​​to the left and to the right of the cell on which it is called. How to do it?

Answer 1

the function returns the sum of the values ​​to the left and to the right of the cell on which it is called

=ДВССЫЛ("R"&СТРОКА()&"C"&(СТОЛБЕЦ()-1);ЛОЖЬ) + ДВССЫЛ("R"&СТРОКА()&"C"&(СТОЛБЕЦ()+1);ЛОЖЬ)