Another approach would be

=SUM(A1:E1)

and custom format General;-General;"-"

--
Regards,

Peo Sjoblom

(No private emails please)


"Ron Coderre" wrote in message
...
Here's the formula you asked for:

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

But, try this first....
FormatCellsNumber Tab
Category: Accounting

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Trying To Excel" wrote:

I am trying to write the if function for the following
If the sum of A1:E1=0 then "-" if not then sum of A1:E1