Puggwash63
Board Regular
- Joined
- Jul 27, 2009
- Messages
- 174
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