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