User FAQs


1) What is the difference between a Formula and an Array Formula ?
Formula - lets you perform a mathematical calculation in a single cell.
Array Formula - lets you perform complicated mathematical calculations in a single cell. These must be entered using (Ctrl + Shift + Enter).


2) What is the difference between Array Formulas and Dynamic Array Formulas ?
Array Formulas spill to a fixed size result
Dynamic Array Formulas spill to a dynamic size result


3) When are Array Formulas converted to Dynamic Array Formulas ?
The curley brackets are automatically removed





© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext