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