View Single Post
 
Old 10-13-2014, 10:22 AM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

The reason this happens is because of your IF statement in P. If there is no data, the formula returns "". While it may look like a blank cell, Excel doesn't treat it the same and any formula that uses it as an operator will result in an error when it is blank.

There are a few ways to get around this. The easiest is to modify your equation as I mentioned above:

=iferror(((round(m28,0)-round(o28,0))*p28),"")
Reply With Quote