percLeft = svc.callFunction(“CEILING”,array(soFar)) - soFar
before the call
before.PNG
after the call
after.PNG
And what is the error? ceiling(0.96)-0.96=1-0.96=0.04=4*10^(-2)=4E-2
the error shows in the after image.
percLeft = 4E-02
What does 4E-02 mean?
Thanks for your help.
4E-02 means 4 * 10^-02:
the letter E (or e) is often used to represent “times ten raised to the power of”
Should that print out as 0.04?
Sorry, if I’m missing something basic, but does that mean that any subsequent calcs using percLeft will have the correct value?
Also, how would I force my calcs to be rounded to 2 decimal places?
Cheers.
found the round function
percLeft = svc.callFunction(“ROUND”,array(percLeft, 2))
“Should that print out as 0.04”
Depends on how your cell is formatted