# Needing cell to show '0' if nothing has been added to another cell

#### Puggwash63

##### Board Regular
I have a formula added into a worksheet (Sheet 1) that tells me whether or not the information is either a 'Plus' or a 'Minus' in different cells. If lets say cell L4 shows the Est order (500) and M4 shows the Act order (565), N4 shows the difference and calculates M4-L4 which will show a 'Plus' of 65. If L4 = 600 and M4 = 550, N4 calculates M4-L4 = -50. The formula I have in Sheet 2 (lets say A1) is =INDEX(Sheet1!\$H\$3:\$H\$29,MATCH(S19,Sheet1!\$K\$3:\$K\$29,0)). How do I show A1 as a '0' if Sheet 1 (M4) has had not figure added. Thanks for reading. Pugg

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
I have a formula added into a worksheet (Sheet 1) that tells me whether or not the information is either a 'Plus' or a 'Minus' in different cells. If lets say cell L4 shows the Est order (500) and M4 shows the Act order (565), N4 shows the difference and calculates M4-L4 which will show a 'Plus' of 65. If L4 = 600 and M4 = 550, N4 calculates M4-L4 = -50. The formula I have in Sheet 2 (lets say A1) is =INDEX(Sheet1!\$H\$3:\$H\$29,MATCH(S19,Sheet1!\$K\$3:\$K\$29,0)). How do I show A1 as a '0' if Sheet 1 (M4) has had not figure added. Thanks for reading. Pugg

Hard to relate the formulas you discuss, although it looks like...

=IF(M4="",0,INDEX(Sheet1!\$H\$3:\$H\$29,MATCH(S19,Sheet1!\$K\$3:\$K\$29,0)))

Is this what you meant?

That was exactly as I wanted and I have added it to the Worksheet and all cells checked and spot on. Many thanks for the quick reply. Pugg

That was exactly as I wanted and I have added it to the Worksheet and all cells checked and spot on. Many thanks for the quick reply. Pugg

That's great.

Replies
7
Views
358
Replies
0
Views
343
Replies
2
Views
2K
Replies
14
Views
613
Replies
4
Views
2K

1,196,235
Messages
6,014,154
Members
441,807
Latest member
sjkenjalo

### 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