G

#### Guest

I am calculating the percentage change between two indices and Excel seems

to have calculated this incorrectly. If I use the ROUND() function to round

to two decimal places the answer in Excel is 3.25 (correct). If i round to 1

decimal place in Excel the answer is 3.2 (INCORRECT). Ofcourse, the answer

should be 3.3. Anyone else aware of this? If so, are there specific instances

in which this happens? The calculation in question uses X=82.6 and Y=80 in

formula

((X-Y)/Y)*100

Thanks

Martin