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?

Please help! Make my 0 become -
//192.168.l.0 - Guide
Xbox-2309-1001-3-0 - Download - Digital stores
Whatsapp-desktop-2-2401-5-0.msixbundle - Download - Instant messaging
Fsutil behavior set disableencryption 0 - Guide
Summertimesaga-0-20-16-pc - Download - Adult games

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

Toshiba Factory Reset Problem

Similar discussions

Subscribe To Our Newsletter!