View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Hide formulas that = 0

You can wrap your formula in an IF statement, such as........

=IF(YourFormula<=0,"",YourFormula)

Vaya con Dios,
Chuck, CABGx3



"Sandy" wrote:

Is there a way that you can keep formulas from showing 0's. I want the
totals to only show when the value is < 0