Previous Topic Next Topic

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

Réponse 1 / 1
RayH
12 Oct 2010 à 11:14
=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