Skip to primary content
Skip to secondary content

Easy-Excel.com

Find Easy Solutions to Your Excel Problems!

Main menu

  • Home
  • About
    • About me
    • About this blog
    • Privacy Policy
  • Cookie Policy
  • Excel in Other Languages
    • Excel Functions in Catalan
    • Excel Functions in Czech
    • Excel Functions in Danish
    • Excel Functions in Dutch
    • Excel Functions in Finnish
    • Excel Functions in French
    • Excel Functions in Galician
    • Excel Functions in German
    • Excel Functions in Hungarian
    • Excel Functions in Italian
    • Excel Functions in Norwegian
    • Excel Functions in Polish
    • Excel Functions in Portuguese (Brazilian)
    • Excel Functions in Portuguese (European)
    • Excel Functions in Russian
    • Excel Functions in Spanish
    • Excel Functions in Swedish
    • Excel Functions in Turkish
    • Excel Functions Translator add-in
  • Useful Shortcuts

Tag Archives: ROUNDUP

How to calculate prices and make them end with a certain number in Excel

Posted on June 9, 2014 by Audun Danielsen
Reply

When you calculate prices you usually know the cost price and the desired profit percentage, so all you have to do is to add the profit to the cost price in order to calculate the sales price. However, the price list might not look as nice as you want:

EasyExcel_43__Round_Ceiling
READ MORE
Posted in Easy Tricks | Tagged CEILING, easy excel, Excel, FLOOR, ROUND, ROUNDDOWN, ROUNDUP | Leave a reply

Categories

  • Charts (4)
  • Conditional Formatting (6)
  • Date & time (4)
  • Easy Tricks (40)
  • Macros (2)
  • Number Formatting (1)
  • Shortcuts (8)
  • Text Functions (6)
  • Tutorials (16)
  • Useless Tricks (2)

Recent Posts

  • How to get Unique values in Excel with one simple formula: UNIQUE
  • How to include the measurement unit in the number format in Excel
  • How to handle tables with empty cells in Excel
  • SUM across multiple sheets in Excel
  • Make SUMIFS and COUNTIFS in Excel more flexible with a Wildcard
  • Summarize a whole table in Excel without writing a formula
  • The easiest way to reduce file size in Excel: Excel Binary Workbook
  • An easier way to calculate compound interest in Excel
  • How to find cells that contain a formula in Excel
  • Unhide all sheets in Excel with a simple macro that works for all your documents

Blogroll

  • Chandoo
  • Excel Shortcuts
  • Excelcharts.com
  • Excelisfun Youtube-channel
  • Mr. Excel Youtube-channel
Privacy Policy Proudly powered by WordPress