removing unneeded information

  • Thread starter Thread starter Cal
  • Start date Start date
C

Cal

In cell AF4 iI have the following formula; =SUM(C4,G4,K4,O4,S4,W4,AA4) with
no data in those cells, cell AF4 shows 0.00. how do I get the cell blank if
the value is 0.00?
 
Hi

=IF(SUM(C4,G4,K4,O4,S4,W4,AA4)<>0,SUM(C4,G4,K4,O4,S4,W4,AA4),"")

Hopes this helps

/Per
 
In cell AF4 iI have the following formula; =SUM(C4,G4,K4,O4,S4,W4,AA4) with
no data in those cells, cell AF4 shows 0.00. how do I get the cell blank if
the value is 0.00?
Click to expand...

You could format the cell to show nothing if the value is 0

Format/Cells/Number/Custom Type: 0.00;-0.00;


--ron
 
Back
Top