» Ignoring Blank Cells when Performing Calculations
CATEGORY - Excel Formula
VERSION - All Microsoft Excel Versions
Problem: 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:
- Mortgages For Dummies®
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Microsoft Access Version 2002 Step by Step
- Personal Finance for Dummies
- Wall Street Journal Guide to Understanding Money and Investing
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
