am trying to come up with a nested statement to make a cell result that shows two decimals as ".00" a blank. The problem is that the result is 6 decimals and has a calculated amount in the last two positions. This allows for it to round to".oo" in the cell,but, I need to make these cells "blank" for presentation purposes....this is a hyperion retrieve application so I can't just "wipe out" the cell.
any help would be greatly appreciated and I would sprerad your good deeds to others!tx...
any help would be greatly appreciated and I would sprerad your good deeds to others!tx...