round to specified number

  1. E

    Round to the nearest 10,000

    Hi, can anyone help me round down to the nearest 10,000 So, if it's 84,000, it'll round to 80,000 If It's 86,000, it'll round to 80,000 etc... I found this online, but it doesn't work properly past 100,000..it just rounds down to the nearest 100,000 when it gets past 100,000...
    • eoinymc
    • Thread
    • round () round down round formula round to specified number
    • Replies: 24
    • Forum: Excel Questions
  2. M

    how to change rounding rules?

    The formula of round currently rounds up if the decimal value is 0.5 and above and rounds down if the decimal value is below 0.5. Is there a way to change this? I want a round up if the decimal value is 0.8 and above and round down if the decimal value is 0.7 and below. E.g. If value is 2.7...
    • miaco11
    • Thread
    • round round formula round function round to specified number rounding
    • Replies: 2
    • Forum: Excel Questions
  3. C

    Excel 2007 Problem: Formula to return the correct price for the quantity given?

    Assume Product is Part A and Qty is 4 for the following fields. What is the formula I need to enter to return the correct price for the given quantity? (I expect the formula to output 25.87) Field values are as follows: A1:Product B1:Price C1:Qty Start D1: Qty End A2:PartA B2:10.35 C2:50 D2:500...
    • caplinq
    • Thread
    • round to specified number sumproduct arrays vlookup multiple values
    • Replies: 6
    • Forum: Excel Questions

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