ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   #Missing (https://www.excelbanter.com/excel-worksheet-functions/200652-missing.html)

Shirley

#Missing
 
Hi,

I am using Hyperion Smart View - similar to excel.

The cells have formula which are suppose to be zero amounts, display
#Missing, instead of 0 or - . The rest of same formula with amount display
the right amount if not equal to zero.

How should I replace #Missing to 0?

Thanks,

Shirley

JLatham

#Missing
 
Shirley,
We can only guess - at least those of us unfamiliar with Hyperion Smart
View. You might post the formula you have in one of those cells that shows
'# Missing' and let us try to guess at a solution.

"Shirley" wrote:

Hi,

I am using Hyperion Smart View - similar to excel.

The cells have formula which are suppose to be zero amounts, display
#Missing, instead of 0 or - . The rest of same formula with amount display
the right amount if not equal to zero.

How should I replace #Missing to 0?

Thanks,

Shirley



All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com