incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 119310] IF Conditional inconsistent
Date Sat, 05 May 2012 03:00:54 GMT
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.

Mime
View raw message