Here are the 4 new functions added:
- LET function assigns names to calculation results and helps you handle multiple computed variables easily, all in the same function.
- Use the =IMAGE() function to insert images into cells
- SPLIT is an antidote to functions like TEXTJOIN and CONCATENATE, meaning you will be able to separate a text string in one cell into different parts spread across adjacent cells in that row based on the delimiter you specify
- With your functions nested inside an IFNA function, you can specify what you want displayed as the result if the nested function hits an NA error.
