>I want all my calculations to be to 1 decimal place.
>
>7/74*100 (the sum currently in hand) should = 9.5.
>
>When I do ROUND(7/74*100,0) I get 9 when 9.5 rounded is actually 10.
>
>To explain more, I have a report that calculates various figures and in the totals are the percentages as well. The only problem is that the total does not reach 100%, it reaches 99%.
How about
ROUND( ROUND(7/74*100,1), 0)
which will first round the number to 1 decimal place, then round that result up or down. 7/74*100=9.46, round to 1 decimal=9.5, round to 0 decimals then = 10.