Lift Vault Forum

Need help to edit a program

I’m considering running this program but I would like to edit the rounding. Anyone good at excel to help me implement rounding the numbers?

Hey there,

I edited the spreadsheet and you should be good to go.

To do this, you just need to use the mround function,

=mround(calculation,rounding)

=mround(10*3.1287,$A$1)

where “$A$1” is the cell, A1, that contains the number you’d like to round to. This lets you easily switch between kg rounding (2.5) and pound rounding (5). The dollar signs just let you paste the formula around the spreadsheet without the cell changing.

More info: https://exceljet.net/excel-functions/excel-mround-function

Let me know if you’re still having issues with it :slight_smile:

Thank you so much dude. Great help :smile:

1 Like