cell show blank, if sum equals zero 1

[harleynana]

if a calculated cell equals zero, can that cell be formatted to show blank and not a 0.

 

[bluedragon2]

=IF(<calculation>=0,"",<calculation>)



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Molby]

Yep use an if statement, an example below

=if(a1+a2=0,"",a1+a2)

 

[mbarron]

This can be done two ways.
1. Go to Tools/ options... Uncheck the Zero Value option on the View tab.

2. Change your formula to:
=if(A1+A2=0,"",A1+A2)

Mike

 

[KenWright]

Or even with Conditional formatting, Select all cells and put in a condition that says format cells that = 0 with a white font.

You could also use a custom format, eg:-

#,##0;-#,##0;;"@"

Format takes the form of Positive/Negative/Zero/Text

The lack of anything between the ;; says to format 0 as blank.

Regards
Ken..............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------