Eric P. Butts

THE Career Site for Accountants and Consultants.

  • Home
  • About
  • Useful Resources
  • Articles
  • Work With Me
    • Breakthrough Resume Writing
    • How to Get Smart in Excel…Fast!
    • Corporate Ladder University (Book)
  • Privacy Policy
  • Terms of Use
  • Disclaimer
  • Login
You are here: Home / Excel / The Excel Tip You Didn’t Know You Needed Until Right Now

March 7, 2019 by Eric Butts Leave a Comment

The Excel Tip You Didn’t Know You Needed Until Right Now

As you know, I like to dabble in a little spreadsheet every now and again.

Tonight I stumbled upon a gem that I had to share.

I was working on a spreadsheet containing a handful of items to auction off ebay style. I had a fair market value (fmv) in one column and wanted the starting bid to be half of the fmv. There was just one problem…only nutjobs start bids at weird numbers like $12, or worse $12.50.

Enter my newfound friend – “ceiling.math”. After a little bit of googling and dodging a landmine of adsense and pop-up ads (my computer is currently revolting), I found this little guy and learned it can round up to the nearest multiple of basically anything.

As in ceiling.math($12.50,5) = $15. Don’t you think that’s much more satisfying to look at? If you need a little more precision and are dealing with something like hourly billings, this can help you there too. For example, if you always round up to the nearest half hour on timesheets for billing clients, ceiling.math has you covered, as in ceiling.math(11.25,.5) = 11.5. Simple.

If you’re swimming in spreadsheets everyday and like little nuggets like this, you’ll want to check out my full Excel training so you can get some high-impact efficiency gains in how you work in Excel.

https://ericpbutts.com/excel-bootcamp

Filed Under: Excel Tagged With: excel formulas

About Eric Butts

I’m a management consultant, MBA and CPA who has a passion for helping others in their career pursuits. Grab my FREE cheatsheet on 12 simple habits of highly successful consultants.

Leave a Reply Cancel reply

You must be logged in to post a comment.

Featured Posts

Business Schools to Blame for Financial Crisis?

How to Get Into Business School – Part 4 (Recommendations)

5 Ways to Influence Gatekeepers Who Want Nothing to Do with You

What Exactly Do Consultants Do?

Case Study: When Should You Protect Your People?

Popular Posts

  • 5 Reasons You Should Be Proud to Ask Dumb Questions at Work
  • What Does It Mean to Have a Sense of Urgency
  • Always Stay Close to the Gatekeepers
  • Why Are There Still So Few Black CPAs?
  • What's the Difference Between FP&A and Accounting?
  • 3 Reasons Average Students Become Good Accountants
  • One Thing You Should Never Do on Linkedin
  • How to Handle Double Standards in the Workplace
  • How to Pass the CPA Exam Without Breaking the Bank
  • Masters in Accounting Isn't The Sweet Treat Some Students Think

Recent Posts

  • How To Customize A LinkedIn Invite From Your Phone
  • Weird non-flex but ok
  • The little video game that could is putting on a masterclass in marketing yourself by picking a fight with two juggernauts
  • Today’s message is brought to you by middle of the night confusion
  • This. Is. Sparta!
  • Privacy Policy
  • Terms of Use
  • Disclaimer

© 2012–2021 Eric P. Butts