https://issues.apache.org/ooo/show_bug.cgi?id=119310
Terry <terauck-aoobugs@yahoo.com.au> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |terauck-aoobugs@yahoo.com.a
| |u
--- Comment #2 from Terry <terauck-aoobugs@yahoo.com.au> 2012-05-05 03:00:54 UTC ---
The error seems to occur only with the start and increment of 0.01 each with a
check figure in B3 greater than 2.46.
Using increments of 0.02 and 0.03 and different check values, the error does
not occur.
The formula needs to be altered from =IF(A5=$B$3;$B$1;A5+$B$2) to
=IF(A5>=$B$3;$B$1;A5+$B$2) to produce the desired result. The new formula
produces the desired results even when using start of 0.01 and increment of
0.01. I cannot understand why the initial formula fails when a higher check
number than 2.46 is used with those start and increment numbers.
--
Configure bugmail: https://issues.apache.org/ooo/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
|