>>Maybe you missed this or I didn't explain it well enough. Since you want to round your value assuming only one decimal place, you can add 1/2 of the next decimal place unit to the number. In your case that would be .05 to be added.
>>
>>So 9.46 + .05, rounded to 0 places would yield 10. 9.44 + .05 would still yield 9, while 9.45 + .05 would yield 10.
>>
>>ROUND(7/74*100
+.05,0) --> 10
>
>Why is this thread continuing to go over the same areas again and again? I think Kevin already has all the answers he needs. Or am I wrong, Kevin?
Good question, David. I saw a fresh response from Kevin explaining why he wanted it to operate the way he wanted it. So I answered it (again). :)