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))

Similar discussions

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

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

133 responses
kmspico password protected
Daniella -
HelpiOS -

5 responses
Diskette Drive 0 Seek Failure- Can't Boot F2
ericnovak -
ali -

7 responses