Prevent calculation if value is 0

Hi there,

Hoping someone out there can help!

I am calculating profit and loss of products by v-looking up the units made from a database then * this by sales price and - by production costs.

However, if the units are 0 it's going into - figures to say we have lost money. I just want to add something to the forumla that stops the calculation if the v-lookup qty is 0

=(VLOOKUP($A2,PRODUCTION!$A:B,2,0)*'Price List'!$B$2)-'Price List'!$C$2

Can anyone help? I'm guessing it's an IF statement but unsure where and how to add it in.

Thanks
Rich

=IF(VLOOKUP($A2,PRODUCTION!$A:B,2,0)=0,"",VLOOKUP($A2,PRODUCTION!$A:B,2,0)*'Price List'!$B$2-'Price List'!$C$2)

Think that has worked. Life saver! Thank you so much