# 0 How do I get rid of "0"

#### agoodson56

##### Board Regular
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?

### Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

#### dispelthemyth

##### Well-known Member
Try

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

#### shyy

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

#### agoodson56

##### Board Regular
Thanks that did the trick!

#### Cool blue

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

#### agoodson56

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

#### dispelthemyth

##### Well-known Member
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

##### Board Regular
Thanks I will give that a try.

Replies
3
Views
233
Replies
1
Views
998
Replies
8
Views
680
Replies
7
Views
299
Replies
28
Views
328

1,195,623
Messages
6,010,749
Members
441,567
Latest member
Flitbee

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back