» Ignoring Blank Cells when Performing Calculations
CATEGORY - Excel Formula
VERSION - All Microsoft Excel Versions
Columns A & B contain numbers as well as empty cells.
We want to be able to multiply each number in column A with the matching number in Column B without getting false results or errors.
Solution:
Use IF, AND, and ISNUMBER functions in the following formula:
=IF(AND(ISNUMBER(A2), ISNUMBER(B2)),A2*B2,"")
Book Store:
Recommended Books:
- Absolute Beginner's Guide to Microsoft Excel 2002
- Microsoft Access 2002 for Dummies
- Understanding Financial Statements
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.
