openoffice-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject DO NOT REPLY [Bug 119310] IF Conditional inconsistent
Date Sat, 05 May 2012 03:00:54 GMT

Terry <> changed:

           What    |Removed                     |Added
                 CC|                            |
                   |                            |u

--- Comment #2 from Terry <> 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:
------- You are receiving this mail because: -------
You are the assignee for the bug.

View raw message