summaryrefslogtreecommitdiff
path: root/calc.go
diff options
context:
space:
mode:
Diffstat (limited to 'calc.go')
-rw-r--r--calc.go21
1 files changed, 17 insertions, 4 deletions
diff --git a/calc.go b/calc.go
index 18605db..cd7fa97 100644
--- a/calc.go
+++ b/calc.go
@@ -6746,7 +6746,7 @@ func (fn *formulaFuncs) IF(argsList *list.List) formulaArg {
var (
cond bool
err error
- result string
+ result formulaArg
)
switch token.Type {
case ArgString:
@@ -6757,13 +6757,26 @@ func (fn *formulaFuncs) IF(argsList *list.List) formulaArg {
return newBoolFormulaArg(cond)
}
if cond {
- return newStringFormulaArg(argsList.Front().Next().Value.(formulaArg).String)
+ value := argsList.Front().Next().Value.(formulaArg)
+ switch value.Type {
+ case ArgNumber:
+ result = value.ToNumber()
+ default:
+ result = newStringFormulaArg(value.String)
+ }
+ return result
}
if argsList.Len() == 3 {
- result = argsList.Back().Value.(formulaArg).String
+ value := argsList.Back().Value.(formulaArg)
+ switch value.Type {
+ case ArgNumber:
+ result = value.ToNumber()
+ default:
+ result = newStringFormulaArg(value.String)
+ }
}
}
- return newStringFormulaArg(result)
+ return result
}
// Lookup and Reference Functions