Hi

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

Hopes this helps

/Per
"Cal" skrev i meddelelsen
...
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?