Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sun, 05 May 2024 05:19:28 +0000

How to Post a Message for Support

Post From: New Spreadsheets OR function

[2014-11-20 23:17:11]
[Go To First Post]
Sawtooth - Posts: 3993
This works:
=IF(OR(A4=0,INT(A3)>INT(A4)),K4+1,K4)

This gives a #VALUE! error:
=IF(OR(INT(A3)>INT(A4),A4=0),K4+1,K4)

Both formulas work in the Old Spreadsheets version.

It errors because row 1003 is blank with a 1000 Number of Rows setting.
In the Old Spreadsheets version, I don't need to check for a 0 in row 1003:
=IF(INT(A3)>INT(A4),K4+1,K4)

1) Why is there a precedence in the OR function?
2) Why is there now a need to check for a 0 in a blank row beyond the Number of Rows setting?