Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Convert text string to valid reference in Excel using Indirect function
  • Multi-criteria lookup and transpose in Excel
  • Two-column Lookup in Excel
  • How to use Excel COLUMN Function
  • Lookup entire row in Excel

Data Analysis Examples

  • Working With Tables in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel
  • Everything about Charts in Excel
  • Number and Text Filters Examples in Excel
  • How to Sort by Color in Excel

Data Validation Examples

  • Excel Data validation allow uppercase only
  • Excel Data validation must not contain
  • Excel Data validation only dates between
  • Excel Data validation must contain specific text
  • Excel Data validation date in next 30 days

Round a price to end in .99 in Excel

by

This tutorials shows how to  Round a price to end in .99 in Excel

If you need to round prices so that they ended in the nearest, .99 value, you can use the ROUND function then subtract .01.

Worked Example:   Calculate years between dates in Excel

Formula

=ROUND(price,0)-0.01

Explanation

The formula shown in the example is:

=ROUND(B6,0)-0.01

With the value in B6 of 63.39, the formula is solved like this:

=ROUND(B6,0)-0.01
=ROUND(63.39,0)-0.01
=63-0.01
=62.99

The ROUND function with a zero will round to the nearest whole dollar. Once rounded, the formula simply subtracts 0.01 to get a .99 value.

Post navigation

Previous Post:

Round a number up to next half in Excel

Next Post:

Round by bundle size in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to extract text between parentheses in Excel
  • TRIM function: Description, Usage, Syntax, Examples and Explanation
  • Split dimensions into two parts in Excel Worksheet
  • SEARCH, SEARCHB functions: Description, Usage, Syntax, Examples and Explanation
  • How to create email address from name in Excel
  • Get day from date in Excel
  • Get first Monday before any date in Excel
  • Display Days in month in Excel
  • Pad week numbers with zeros in Excel
  • How to calculate workdays per month in Excel
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate principal for given period in Excel
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
  • AMORLINC function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARDE function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles