Microsoft Excel: Correcting an MROUNDing error

By J. Carlton Collins, CPA

In the July 2018 item "Microsoft Office: Rounding Time in Excel," this column stated that "the MROUND function always rounds up, away from zero." It should have stated that "the MROUND function always rounds up, away from zero, when the number is greater than or equal to half the value of the multiple." For example, assuming a multiple of 6, the MROUND function will round the numbers 1, 2, 3, 4, 5, and 6 to 0, 0, 6, 6, 6, and 6 (values that are all multiples of 6). The numbers 1 and 2 are rounded down because they are lower than half the value of 6, which, of course, is 3. Thanks to Mark Huff, CPA, for bringing this to our attention.   

techqa-10

About the author

J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a conference presenter, and a JofA contributing editor.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

VIDEO

Excel walk-through: Sparklines

Want to liven up your spreadsheets with some color and graphical elements? Kelly L. Williams, CPA, Ph.D., shows how to use Excel sparklines, which illustrate data trends and patterns via small charts that fit in a single Excel cell.

PODCAST

What’s next for potential CPA licensure changes

A new model proposed by NASBA and the AICPA is designed with an eye on the future for newly licensed CPAs. The AICPA's Carl Mayes, CPA, provides background on the project and a look ahead to 2020.