chung asked in 電腦與網際網路軟體 · 1 decade ago

# openoffice Calc之中if函數的使用層數

Rating
• 1 decade ago

在OpenOffice 的討論區有提到您所提到的限制, 限制有兩個

1.IF()的巢狀層數限制為 40 階.

2.公式字元最多 1023 個字

超出以上兩個限制之一即會產生錯誤

以下節錄討論片斷:

OOo limits....

IF() nesting to 40 levels deep.

formula in a cell can be up to 1023 characters.

If you could write a 41 level deep IF() in less than 1023 characters,it would fail with Err514, which (logically by deduction) means thatyou have exceeded the 40 nesting limit.

If you can write a 40 (or less) level deep IF() that exceeds 1023characters in the cell formula, then it will fail with Err512, which(logically by deduction) means that the formula has invalid syntax.Probably because you could not fit in all of the required closingright-parenthesis.

There are two different limits. You must not exceed either one. Atrow 40, the first limit is exceeded giving Err514. At row 57 the otherlimit is exceeded giving Err512, and so we don't get far enough to eventry to evaluate the formula.

• 1 decade ago

支持OPEN反對MS