...
How to start using "Inline Table Editing" macro
Features
Changes will be saved automatically after 60 seconds
Clipboard, Copy & Cut allows you to easily copy, cut and paste data from and into your table
High-speed formula calculations. Function syntax compatible with Excel and Google Sheets
Basic formulas and calculations
Any numbers, negative and positive as float or integer;
Arithmetic operations such as:
+
,-
,/
,*
,%
,^
;String operations such as:
&
(concatenation eq.=-(2&5)
will return-25
);Relative and absolute cell references such as:
A1
,$A1
,A$1
,$A$1
;Comparison operations such as:
=
,>
,>=
,<
,<=
,<>
;
Logical operations such as:
AND()
,OR()
,NOT()
,XOR()
;All JavaScript Math constants such as:
PI()
,E()
,LN10()
,LN2()
,LOG10E()
,LOG2E()
,SQRT1_2()
,SQRT2()
;Error handling:
#DIV/0!
,#ERROR!
,#VALUE!
,#REF!
,#NAME?
,#N/A
,#NUM!
;Build-in variables such as:
TRUE
,FALSE
,NULL
;
...