Previous Topic Next Topic

Please help! Make my 0 become -

Closed
Excel Beginner - Oct 11, 2010 at 04:58 PM
 RayH - Oct 12, 2010 at 11:14 AM
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

Answer 1 / 1
RayH
Oct 12, 2010 at 11:14 AM
=IF(SUM(A1:F1)=0,"-",SUM(A1:F1))
0

Similar discussions

,">"&0),"") at the end of a countif formula
jutulu -
toony -

4 responses
Toshiba Factory Reset Problem
aliggett63007 -
aliggett63007 -

3 responses
Restoring Toshiba laptop to factory settings
confused -
Kozzo -

43 responses
Toshiba recovery without a CD
Vixen -
Stamatis -

4 responses
Diskette Drive 0 seek failure (error message)
azajewel -
TechIlliterate -

133 responses