Ask Your Question

Max number of nested "IF" statements in Calc? [closed]

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

appreciatethehelp gravatar image

updated 2020-09-26 11:54:17 +0200

Alex Kemp 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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2020-09-16 07:32:16.726366

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


IFS() was a very useful tip, cheers!

appreciatethehelp gravatar imageappreciatethehelp ( 2020-09-16 07:32:55 +0200 )edit

Question Tools

1 follower


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

Seen: 429 times

Last updated: Apr 13 '20