Support Board
Date/Time: Sun, 22 Dec 2024 06:17:41 +0000
Post From: New Spreadsheets OR function
| [2014-11-20 23:17:11] |
| Sawtooth - Posts: 4141 |
|
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? |