Max number of nested "IF" statements in Calc?

[appreciatethehelp]

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.

Thanks.

[erAck]

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

[keme]

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().

[appreciatethehelp]

IFS() was a very useful tip, cheers!