diff options
| author | bailantaotao <Edwin@am.is> | 2021-08-12 14:53:59 +0800 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2021-08-12 14:53:59 +0800 |
| commit | 61d0ed1ff26fbe47b4bfdc6adbc6db09743beb3a (patch) | |
| tree | c854f94ec251a268a56628d9b52b5f87e3ce4df2 /calc_test.go | |
| parent | 43a057b1eaeb810495618d70c2dc2d3e5df1fea4 (diff) | |
This closes #987: support nested calc for if formula (#988)
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", |