Live Chat Software by Kayako |
Knowledgebase: Microsoft Excel
|
Avoiding the #VALUE! Error When Adding Cells That May Contain Blanks
Posted by - NA - on 20 March 2006 08:48 AM
|
|
|
Problem: The following formula: =IF(A5>0,B5+C5-A5) returns the #VALUE! error because an inadvertant blank space is stored in cell B5. Solution: Use the IF and SUM functions as shown in the following formula: =IF(A5>0,SUM(B5:C5)-A5) | |
 (181 vote(s)) This article was helpful This article was not helpful |
|
Comments (0)