Rounding to retail prices in Excel
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
Watch video Rounding to retail prices in Excel online without registration, duration hours minute second in high quality. This video was added by user The Finance Storyteller 16 July 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,772 once and liked it 75 people.