A formula with many conditional operations is considered smelly. Many conditional branches make a formula hard to read and understand.
F. Hermans, M. Pinzger, A. van Deursen. “Detecting Code Smells in Spreadsheet Formulas”. ICSM 2012, pp. 409–418.
All rights reserved (c) Tushar Sharma 2017-23.