Excel Articles
  • Power Excel Book Excerpts
  • MrExcel Seminars
  • MrExcel Message Board
  • MrExcel Store

MORE RESOURCES
FOR MICROSOFT EXCEL

  • Excel VBA Book
  • MrExcel 2022 Boosting Excel
  • Learn Excel from MrExcel

Microsoft MVP

Power Excel from MrExcel


  • Rank Scores
  • Rank a List Without Ties
  • Sorting with a Formula
  • Round Numbers
  • Round to the Nearest $0.05 with MROUND
  • Round Prices to the Next Highest $5
  • Round 0.5 towards Even Per ASTM-E29
  • Separate the Integer From the Decimals
  • Why Is This Price Showing $27.85000001 Cents?
  • Calculate a Percentage of Total
  • Calculate a Running Percentage of Total
  • Use the ^ Sign for Exponents
  • Raise a Number to a Fraction to Find the Square or Third Root
  • Calculate a Growth Rate
  • Find the Area of a Circle
  • Figure Out Lottery Probability
  • Help Your Kids with Their Math
  • Convert Units
  • Match Web Colors with HEX2DEC
  • XOR Find People Who Chose a Single Value?
  • Find the Second Largest Value
  • Format Every Other Row in Green
  • Use IF to Calculate a Bonus
  • IF with Two Conditions
  • Tiered Commission Plan with IF
  • Display Up/Down Arrows
  • Stop Showing Zeroes in Cell Links
  • Count Records That Match a Criterion
  • Build a Table That Will Count by Criteria
  • Sum Records That Match a Criterion
  • Can the Results of a Formula Be Used in SUMIF?
  • Calculate Based on Multiple Conditions
  • Avoid Errors Using IFERROR
  • Multiple Conditions Using SUMPRODUCT
  • Use VLOOKUP to Join Two Tables
  • Every VLOOKUP Ends in False
  • Lookup Table Does Not Have to Be Sorted
  • Beware of #N/A from VLOOKUP
  • Add New Items to the Middle Of Your Lookup Table
  • Consider Naming the Lookup Table

  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8

MrExcel.com & related websites debuted on November 21, 1998.

ExcelArticles.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

This site contains affiliate links. Any affiliate commissions that we earn when you click a link to Amazon or other sites is reinvested in keeping MrExcel.com and ExcelArticles.com running.
You can earn a commission for sales leads that you send to us by joining our affiliate program.

Privacy Policy | Cookies Policy

Do not share my Personal Information.

Excel® is registered trademark of the Microsoft Corporation.
MrExcel® is a registered trademark of Tickling Keys, Inc.

© 1998 - 2023 by MrExcel Publishing. All rights reserved.