Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Lourdes Edwards   on Sep 30 In MS Office Category.

  
Question Answered By: Jay Brown   on Sep 30

I managed to make up the workaround and get highly desirable zero.

I try to answer all your posts concerning the problem in a fcfs
manner.

The original formula was:

=IF(BH3=0;"N";IF(BK3-AE$12<=0;"P";BK3-AE$12))
repeated 1499 times in BM3:BM1502

The part of the formula which should return 0 but returned 2.22045E-16
is BK3-AE$12.
Referenced value in column BK3:BK1502 is the increasing amount of
sent messages
of analyzed billing calculated with =IF(BH3=1;SUM($BJ$3:BJ3);0).
AE$12 is a place where a user puts the value of the messages pack.
It can be 10 20 or 50. The cost of a single message can be 0.1 0.2 or
0.4.

Definitely it is not a rounding problem then.
The values the formula returns include between -50 and 50 and it is
calculated with adding or subtracting 10 20 50 0.1 0.2 0.4.
All is calculated in a default number format so I can see 2.22045E-16
at once.

After a day of extensive search I have tried all I could think of to
get rid of 2.22045E-16. I have run out of ideas and finally the
approach of that hp calc fan I mentioned in my original post have
worked: Do not use parenthesis – he says (here I can be
extravagant
and put even two ; ).

I changed original formula
=IF(BH3=0;"N";IF(BK3-AE$12<=0;"P";BK3-AE$12))
to
=IF(BH3=0;"N";IF(BI3<=0;"P";BI3))
and put
BK3-AE$12
in
BI3:BI1502

It works. Discrepancy reduced to zero.
And definitely I have learnt how much the zero is.

Bug found? Maybe.

So remember no parenthesis and keep calm.

Share: