Getting Started
There are four different types of arguments that can be passed into a function
* single lteral value
* array of literal values
* reference to a single cell
* reference to a rectangular range of cells
Excel will always try to convert arguments that are passed into functions
This applies to built-in functions, vba functions and third party add-in functions.
There are six different types of data that a function can return
* Number (floating point)
* Boolean
* String (unicode)
* Error (#value!, #num!)
* Array
* Cell/Range References (indented for interim calculations, single cell references will be automatically converted)
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext