Please help! Make my 0 become -

Closed
Excel Beginner - 11 Oct 2010 à 16:58
 RayH - 12 Oct 2010 à 11:14
Hello,

I have a simple formula "=sum(A1:F1)" The formula automatically shows as "0", but I want it to show as "-" if the answer is zero.

Will someone please help me?


Related:

1 response

=IF(SUM(A1:F1)=0,"-",SUM(A1:F1))