When building "slightly complex functions" in spreadsheets, it used to be a daily occurrence for me to spend 30 minutes searching online. Nested IF functions, combinations of VLOOKUP and IFERROR, bulk ...