Limiting the value returned by calculations
 

I need to show the value of a calculation whereas the value displayed must be
disiable by 10. IE: the calculation equals 102, but I need only show 100 or
if the calculation equals 105 I need it to display 110, basically the
calculation can be any amount but can only be displayed as a multiple of 10,
no decimal points are allowed

Limiting the value returned by calculations
 

assume your calculation is
=A2/B2
enter
=ROUND(A2/B2,-1)

Greetings from New Zealand
"WavMaster" wrote in message
...
I need to show the value of a calculation whereas the value displayed must
be
disiable by 10. IE: the calculation equals 102, but I need only show 100
or
if the calculation equals 105 I need it to display 110, basically the
calculation can be any amount but can only be displayed as a multiple of
10,
no decimal points are allowed