0 How do I get rid of "0"

[agoodson56]

I have a formula the equals 0 (=WRK!IL462) until something is in cell WRK!IL462. I need cell MTL!C7 that has the formula =WRK!IL462 in it not to show the 0. How can I do this?

 

[dispelthemyth]

Try

=if(WRK!IL462="", "", WRK!IL462)

 

[shyy]

put an IF condition so =IF(WRK!IL462=0,"",WRK!IL462 This will show blank if the formula evaluates to 0.

 

[agoodson56]

Thanks that did the trick!

 

[Cool blue]

ADVERTISEMENT

Custom number formatting would be a cleaner way to achieve this.
FmtPos;FmtNeg;""

 

[agoodson56]

How does the custom numbering work. How do I enter it?

 

[dispelthemyth]

Press Alt + 1, select the Tab labelled "Number"
In category choose "Custom", and in type enter the below excluding the ""
"0;[Red]0;"

That will format -ve numbers in Red and +ve normally, number a Zero will become a blank (invisble, but the space will still contain a 0, it just cant be seen)

"

How does the custom numbering work. How do I enter it?

 

[agoodson56]

Thanks I will give that a try.