Calculating by presented values

[paallikko1]

Hi

I would like to sum values as they are shown in cells not the exact values.

Example: (I present only one decimal)

Cell A1: =1/3=0,3
Cell A2: =1/3=0,3
Cell A3: =A1+A2=0,7

I would like that Excel calculates by rounded values so A3 should give 0,6. So what I should do?

Thank you for help

[Pepe Le Mokko]

Perhaps use the ROUNDDOWN function ?

[rajeshturaha]

Try
ROUNDDOWN(SUM(A1:A2),1)