Zero result = Blank cell

Patchcord

Board Regular
Joined
Sep 30, 2003
Messages
73
I'm calculating time and need a zero result to produce a blank cell instead of zero.

Does anyone know how to achieve this?
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

yeheya

Board Regular
Joined
May 20, 2004
Messages
162
Can you explain a bit your requirement with example?

Regards,
Yeheya
 

Patchcord

Board Regular
Joined
Sep 30, 2003
Messages
73
Yes, I'm just adding up hours worked ie:

=SUM(A1:A10)

If no hours are worked, the result is zero. I need the cell to be empty if no hours are worked.
 

yeheya

Board Regular
Joined
May 20, 2004
Messages
162
Put the formula like this:

=if(SUM(A1:A10)=0,"",SUM(A1:A10))

Regards,
Yeheya
 

Watch MrExcel Video

Forum statistics

Threads
1,118,456
Messages
5,572,241
Members
412,450
Latest member
Heba
Top