Posted 8 September 2017, 2:19 pm EST
I have a problem with decimals in a cell formula.
A column of the spread is calculated using the following formula: (FC6*FC8)-((FC6*FC8)*(FC9/100))-(((FC6*FC8)-((FC6*FC8)*(FC9/100)))*(FC10/100))
If the cell values are as follows:
c6 = 5
C8 = 2.79
c9 = 25
C10 = 0
The result of the formula is 10.4625
In the column that displays only two decimal places so the value is 10.46
I have eight rows where the value is always the same and in the ninth row do the sum by a new formula: SUM(R1C:R8C)
I'm hoping that the result is 83.68 but the formula returns me 83.7
How I can eliminate from the calculation that I am not showing decimal places?
I am using version 4.0.3509.2008.
Thanks for your help.