#Value Error

Hi Gents,

I cant seem to get my head around this error. I get a #VALUE! error in column Q (formula =L6+M6+N6-O6-P6), i know its related to the formula's located in column L (Formula =IF('1st QTR BAS'!M15=0,"",'1st QTR BAS'!M15)), N (Formula =IF('1st QTR BAS'!G5=0,"",'1st QTR BAS'!G5)) and P ( Formula =IF('1st QTR BAS'!G7=0,"",'1st QTR BAS'!G7)).

Your assistance will be much appreciated.

Ash