Excel Tips
Separate the Integer From the Decimals »
February 28, 2022
I have a column of values that include digits before and after the decimal point. I don’t want to round anything, I just want the whole number. Or, I just want the decimal. How can I easily break those apart?
Round 0.5 towards Even Per ASTM-E29 »
February 25, 2022
Excel always rounds 0.5 up to the next integer. The latest best practice in rounding says to round 0.5 towards the even number.
Round Prices to the Next Highest $5 »
February 24, 2022
I handle pricing for a company, and I have a spreadsheet that shows my cost per SKU. My manager tells me to take the current manufacturing cost for each item, multiply by 2, add $3, and then round up to the next highest multiple of 5.
Round to the Nearest $0.05 with MROUND »
February 23, 2022
I know I can use the ROUND function to round to the nearest dollar or penny. How do I round to the nearest nickel or quarter?
February 22, 2022
My formula is producing results with many decimal places. I need to round to the nearest cent or nearest dollar or even to the nearest hundred dollars.
February 18, 2022
In “Rank Scores,” I learned how to use the RANK function to find the relative rank order of four writers. Now I want to use a formula to produce a sorted list of the writers in high-to-low sequence.
February 16, 2022
I have four writers working on a project. Each week, I need to report how many pages they have written toward their goal. I want to add a formula to rank them in high-to-low order.