All geek questions in one place

What is the purpose of the prefix + in excel, in-cell formulas?

I inherited a spreadsheet project that is populated with cell references with the previous “+”. What does it mean?

Example: "= + Sheet2! A3"

Also, when I click inside the formula bar, the name area on the left says “OFFSET”. Does this have anything to do with the "+"?

+3
source share
3 answers

The previous +one does nothing. It's like that +2, and 2- this is the same number as +(-x)and (-x).

- +. . , , , , =, - +. + -, Excel = , . :

  • , +, , .
  • , =, .
  • - numpad +, , =.

OFFSET ; .

+4

"+" . "-" , "+" , , "= Sheet2! A3"

+1

This offset may mean that the value exceeds the maximum or minimum value (for example, Excel uses 32-bit fields to store numbers) or refers to a cell that does not exist (maybe you are trying to pass a column after AMJ or a row after 65535). In a more general sense, “Offset” usually refers to a value that is out of range.

0
source

Source: https://habr.com/ru/post/1788282/

More articles:


All Articles