What Types of Functions Can Be Used in AIV Spreadsheet Formulas?

AIV supports a variety of functions in spreadsheet formulas, enabling efficient data analysis. The primary categories include:

1. Mathematical Functions: Common functions such as SUM, AVERAGE, and COUNT allow for basic calculations.
   
   
2. Logical Functions: Functions like IF, AND, and OR help evaluate conditions and make decisions based on logical tests.
   
   
3. Text Functions: Use functions such as CONCATENATE and LEFT to manipulate and format text data.
   
   
4. Date Functions: Functions like TODAY() and DATEVALUE() assist in handling and analyzing date-related data.
   
   

For more information, check the official documentation on Spreadsheet Functions in AIV.