diff options
Diffstat (limited to 'calc_test.go')
| -rw-r--r-- | calc_test.go | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/calc_test.go b/calc_test.go index 20505fc..54bdc01 100644 --- a/calc_test.go +++ b/calc_test.go @@ -1090,6 +1090,8 @@ func TestCalcCellValue(t *testing.T) { `=IF(1<>1, "equal", "notequal")`: "notequal", `=IF("A"="A", "equal", "notequal")`: "equal", `=IF("A"<>"A", "equal", "notequal")`: "notequal", + `=IF(FALSE,0,ROUND(4/2,0))`: "2", + `=IF(TRUE,ROUND(4/2,0),0)`: "2", // Excel Lookup and Reference Functions // CHOOSE "=CHOOSE(4,\"red\",\"blue\",\"green\",\"brown\")": "brown", |