Rounding to retail prices in Excel

Опубликовано: 16 Июль 2023
на канале: The Finance Storyteller
2,772
75

It is very common in retail to use psychological pricing, with prices ending in 99 cents, rather than a round number.

Let me show you a way in Excel to round up to the next 99 cents. Over here on the left in column A, we have the “raw” number: the cost or wholesale price plus a markup. In column B, I have all of these numbers rounded up to the next 99 cents. How? Using the ROUNDUP function in Excel. Round up the value in cell A2 to the next whole dollar. No decimals, as indicated by the zero. Then simply deduct one cent from it in all cases, and you have all retail prices ending in the next 99 cents.

Philip de Vroe (The Finance Storyteller) aims to make accounting, finance and investing enjoyable and easier to understand. Learn the business and accounting vocabulary to join the conversation with your CEO at your company. Understand how financial statements work in order to make better investing decisions. Philip delivers #financetraining in various formats: YouTube videos, livestreams, classroom sessions, and webinars. Connect with me through Linked In!

Want to get access to bonus content, and/or express your gratitude by buying me a cup of tea? Join my channel as a member through    / @thefinancestoryteller  


Смотрите видео Rounding to retail prices in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь The Finance Storyteller 16 Июль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,772 раз и оно понравилось 75 людям.