Excel Tips
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.
What-If For 3 Or More Variables »
February 15, 2022
The previous trick is cool, but what if I have three or more variables to change?
Random Walk Down Wall Street - Random Functions »
February 14, 2022
While judging the ModelOff World Financial Championships in New York in 2012, I met professor Simon Benninga and he demonstrated a very different use for data tables.