round off function

  1. B

    Excel Round off formula to get desired result

    Which uniform excel round off formula should I use to get the following result by multiplying certain figures by 2.57?: 6600*2.57 = 17000 7680*2.57 = 19700 11040*2.57 = 28900 12750*2.57 = 33400
  2. M

    Round function with floor

    i calculating some late arrivals in my company. A person if late for 4 times, its half day i.e.- penalty 0.5 A person if late for 6 times, its full day i.e. - penalty 1.0 so I have been using the FLOOR function for the same. for e.g. A- Number of Late Arrivals B- Number of days...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top