True value vs displayed value

[Excelezz]

hello everyone
Hope all is doing great and i need your help please with this maddening matter
i have a cell contains a formula as follows noting j4=148,495,950.67
-IF (MOD (J4*0.00521)*10000,10)>=5, ROUND((INT ( (J4*0.00521)*1000)+1) / 1000,2), ROUND(J4*0.00521, ROUND(J4*0.00521,2))
The result is correct which is (773,663.90)
And another cell which is I10 that’s based on the above result which is as follows noting e9 is (773,663.90) and k16 is zero
-IFERROR (IF (MOD((IF (K16<>0,K16+E9,E9))*10000,10)>=5, ROUND((INT ((IF (K16<>0, K16+E9,E9)) *1000)+ 1)/1000, 2), ROUND (IF (K16<>0, K16+E9, E9), 2)),
"0")
The displayed value in I10 is 773,663.91 yet the true value in it is 773,663.90


Can someone help me with this i don't understand the reason

 

[Excelezz]

Not with the figures that you gave me, even without the last round it is still giving me .90. Are the values in K16 an E9 the results of formula? Have you stepped through with formula - evaluate?

Can you post your calculations with XL2BB (including any cells E9 and K16 are getting info from)?

When you state "true value" is that something you are seeing in Excel or by your calculations?

Look here is a step by step of what i do

j4= 148,495,950.67 and E9 result inner and displayed value is ( 773,663.90 ) two decimals places a result of this formula
=IF(MOD((J4*0.00521)*10000,10)>=5,ROUND((INT((J4*0.00521)*1000)+1) / 1000,2),ROUND(J4*0.00521,2))

Now in cell I10 i have this formula in it it displays
773,663.91 but the inner value is

=IFERROR(IF(MOD((IF(K16<>0,K16+E9,E9))*10000,10)>=5,ROUND((INT((IF(K16<>0,K16+E9,E9))*1000)+ 1)/1000,2),ROUND(IF(K16<>0,K16+E9,E9),2)),"0")

so how is the inner value is 90 and the displayed value is 91? where is come from ?? tha's what i want to understand how the inner is something yet the displayed is another noting that when i make it into another cell it gives me 91 knowing as well that in a different cell i get 90


the last pic is showing I16 showing 91 meanwhile L9 referencing the same cell showing 90

 

[MARK858]

First of all MOD((IF(K16<>0,K16+E9,E9))*10000,10)>=5 is FALSE, it is the last E9 you should be looking at (you would see this if you stepped through with Formula - Evaluate as I suggested)

Having said that with the numbers you have stated I do not get the same result, if I put the formula

=I10

in I16, click I16 then click inside the

=I10

in the formula bar and press F9 I get

Note no trailing 0 (which there shouldn't be if it is a real number and the true underlying value).
The same when I hover over =I16

As I cannot replicate your issue I am afraid that I cannot assist you anymore in this thread, hopefully someone else might have an idea.

 

[Excelezz]

First of all MOD((IF(K16<>0,K16+E9,E9))*10000,10)>=5 is FALSE, it is the last E9 you should be looking at (you would see this if you stepped through with Formula - Evaluate as I suggested)

Having said that with the numbers you have stated I do not get the same result, if I put the formula

=I10

in I16, click I16 then click inside the

=I10

in the formula bar and press F9 I get

View attachment 123642

Note no trailing 0 (which there shouldn't be if it is a real number and the true underlying value).
The same when I hover over =I16

View attachment 123644


As I cannot replicate your issue I am afraid that I cannot assist you anymore in this thread, hopefully someone else might have an idea.

Your are tremendously thanked for your help all along and much gratitude for your attempts

 

[Excelezz]

Any help guys?