ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   rounding of numeros (https://www.excelbanter.com/excel-worksheet-functions/145974-rounding-numeros.html)

valtinho

rounding of numeros
 
As to make with that the result (a*b)*(c) =

Necessary to use fracionarios numeros and that they are rounded off in
multiplos of 5.
column column calculates former
0,456 = 0,500
0,530 = 0,550
0,550 = 0,550
0,565 = 0,600

example a5 * b5 * c5 = (0,460*0,565)*(1) = 0,30



JMB

rounding of numeros
 
this appears to be the same question as your previous post (to which you have
several responses). if none of those responses resolve your issue, you
should respond in your original thread and clarify why their suggestions are
not working.



"valtinho" wrote:

As to make with that the result (a*b)*(c) =

Necessary to use fracionarios numeros and that they are rounded off in
multiplos of 5.
column column calculates former
0,456 = 0,500
0,530 = 0,550
0,550 = 0,550
0,565 = 0,600

example a5 * b5 * c5 = (0,460*0,565)*(1) = 0,30




All times are GMT +1. The time now is 12:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com