Limiting the value returned by calculations

W

WavMaster

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
 
B

Bill Kuunders

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

Greetings from New Zealand
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying multiples of 10 5
Displaying specific numbers 0
formula to select value from 8 cells 5
Timesheet calculations 1
Calculating monthly values for a certificate of deposit. 13
Percentage change 9
Calculate sum of values based on a ref value, how? 4
Calculating averages on a form 3

Top