A Substitute for the Hard-to-Reach Equal Sign

BY STANLEY ZAROWIN

Why don’t computer manufacturers put an equal sign (=) in a more convenient place on keyboards? It’s such a pain to find that out-of-the-way key we use in so many Excel formulas.

The answer is simple: Keyboard designers aren’t accountants. But cheer up, here’s a simple work-around. When you enter a formula, Excel—which does know the habits of accountants—immediately recognizes that you’re writing a formula. So it lets you go to your favorite geography on the keyboard, the numeric keypad, and use its plus (+) key instead of the main keyboard’s =.

If you type +(C1+C2) and press Enter , Excel adds the requisite = and ignores the + in the calculation. Notice that both the + and the = appear in the formula bar, but Excel includes only the = in its calculation (see screenshot).

SPONSORED REPORT

States look to unclaimed property for revenue

This free report outlines the escheat process, common types of AUP, how different states are handling it and how companies can plan for potential audits and liabilities.

PODCAST

Using drones to enhance audits

Hermann Sidhu, CPA, global assurance digital leader at EY, walks us through EY’s exciting new project to use drones to help audit large warehouses and outdoor inventories.