But consider this modified version of the same formula:Įven without context, the formula is self explanatory “ Take the order subtotal and deduct the discount, then multiply the result by the New York state sales tax.” Named ranges make any formula easier to read. The only obvious logic is that there is some subtraction and multiplication taking place. Without any context given to the formula, the viewer has no idea what this is supposed to produce.

Excel Named Ranges are a great way to turn ugly, confusing formulas into easy to read statements.