If you want to round a price to nearest nickel (multiple of 0.05), or a length to the nearest inch (multiple of 1/12), or a number of minutes to the nearest second (multiple of 1/60), you can use the following formula (where mult is the multiple to round to):
Category: Smart Excel Tips
Excel Formula to count the occurrences of text, characters, or words in a cell
Formula that will let you count how often a text character appears in a single cell? This tutorial has exactly what you’re looking for.
Apply shading to alternate rows using Conditional Formatting
It is often easier to read lists of data if alternate rows are shaded. This article shows you how to use conditional formatting to shade alternate rows.
Excel tip: Instant in-cell graphs with worksheet formulas
Lately there has been great interest in lightweight in-cell charting, using worksheet formulas and sometimes a special font, to display values graphically.
Choose the Right Chart Type for your Data
The world today has way too much data, but very little information. In this tutorial I’ll show you how to convert your data into powerful information by selecting the right charts for expressing them.
Excel 2013: Conditional Formatting
This page describes the Conditional Formatting tool. Use Excel conditional formatting to color rows, hide duplicates, highlight items or hide errors.
Formulas and Structured Data in Excel Tables
Structured references make it much easier and more intuitive to work with table data when you are using formulas that reference a table, either portions of a table or the entire table. They are especially useful because table data ranges often change, and the cell references for structured references adjust automatically. This minimizes the need to rewrite formulas as rows and columns are added and deleted in a table, or when external data is refreshed.
How to create a dynamic chart
We all know that to make a chart we must specify a range of values as input. But what if our range is dynamic and keeps on growing or shrinking. Wouldn’t it be cool if the ranges were dynamic and charts get updated automatically when you add (or remove) rows?
Working with Tables in Excel 2013, 2010 and 2007
Excel tables, (known as lists in excel 2003) is a very powerful and supercool feature that you must learn if your work involves handling tables of data.
Excel Circular References – How to deal with them?
In Excel, a circular reference is created when you refer to same cell either directly or indirectly. Learn more about Excel Circular References here.