This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying to ignore a #REF! error code in a calculation. Here is my dilemma: Example: I need to calculate Total Assigned, - Total Loss, + Total Gain = NEW Total Assigned. some total loss' or gains will be #REF! because there aren't any present on the pivot table. Because of the #REF!, the previous calcuation also has a #REF!. How can I ignore the #REF! in my calcualtion to allow a number to appear?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Post you question in the Office Excel IT Pro forum link below:
http://social.technet.microsoft.com/Forums/en-US/excel/threads