Ask Your Question

Max number of nested "IF" statements in Calc?

asked 2020-04-13 08:06:15 +0200

appreciatethehelp gravatar image

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.


edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-04-13 14:55:02 +0200

erAck gravatar image

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

edit flag offensive delete link more

answered 2020-04-13 14:22:12 +0200

keme gravatar image

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

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-04-13 08:06:15 +0200

Seen: 133 times

Last updated: Apr 13