Limiting the value returned by calculations

  • Thread starter Thread starter WavMaster
  • Start date Start date
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
 
assume your calculation is
=A2/B2
enter
=ROUND(A2/B2,-1)

Greetings from New Zealand
 
Back
Top