|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#16
10-13-2014, 10:22 AM
|
|||
|
|||
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),"") 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating new field in pivot table based off existing field | laceymarie1987 | Excel | 0 | 06-26-2014 12:13 PM |
 Form field calculation returning 2x correct result
|
Jschueller | Word | 1 | 08-20-2013 01:51 PM |
|
Rules based due date calculation
|
dlowrey | Excel Programming | 3 | 05-12-2013 08:30 PM |
| Prevent Field Calculation with Dates from introducing line break? | ztag | Word | 1 | 01-13-2012 04:13 PM |
|
Mail Merge Calculation Error
|
Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode