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

[Puggwash63]

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

 

[Aladin Akyurek]

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?

 

[Puggwash63]

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

 

[Aladin Akyurek]

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.