Max number of nested "IF" statements in Calc?

I read somewhere that MS Office has a max number of nested IF statements of 7, so I wondered if Libreoffice also has a limit on how many can be nested?

Figured I’d ask the question here in case anyone else is wondering, in lieu of testing it myself.


The maximum number of nested expression levels is 42, no matter if IF() or other functions.

I just created a formula where IF() was nested 18 levels deep. No problem in Calc, nor in Excel. Your information is most likely outdated.

That said, the IFS() function is often a good alternative to nested IF().

IFS() was a very useful tip, cheers!