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 / Archives for excel formulas

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

January 21, 2017 by Eric Butts Leave a Comment

How to Get More Out of OR in Excel (Video)

Filed Under: Excel Tagged With: excel formulas, excel videos

January 21, 2017 by Eric Butts Leave a Comment

How to get more out of OR in Excel

 

I don’t always like to use helper columns but when I do, the OR function comes in handy. There are a couple of scenarios where I find this useful. [Read more…]

Filed Under: Excel Tagged With: conditional formulas, embedded formulas, excel formulas

November 6, 2016 by Eric Butts Leave a Comment

How to Count Characters in a Cell in Excel

How to use the Len Formula

Have you ever needed to know how many characters were in a cell?

It sounds a little ridiculous but I found myself in that exact position a couple of weeks ago. [Read more…]

Filed Under: Excel Tagged With: excel formulas

June 7, 2016 by Eric Butts 3 Comments

How to Calculate Payback Period in Excel (with Automated Updates)

How to calculate payback period
Click if you want a copy of the Excel workbook and video

You’d be surprised how simple the calculations are that sophisticated investors rely on. Payback period is one such example. [Read more…]

Filed Under: Excel, Management Consulting Tagged With: abs, countif, excel, excel formulas, index

  • 1
  • 2
  • Next Page »

Featured Posts

Why All Your Years of Experience Mean Nothing

The Most Effective Way To Network So Everyone Knows Your Name

Consultants Get Paid For One Thing Only (and it’s not what you think)

How to Get Into Business School – Part 1 (GMAT)

How The First Rule of Fight Club Helped Me Cope With So Much Business Travel

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