can you provide a snap shot of what you are trying to do?

does the data on sheet 2 change or is it always looking at the same thing but returning a different result once you adjust sheet 1??

are you using more than one formula on sheet 2 to refer to the result of that IF formula?

having more than one work off the outcome of a single outcome might be you issue.

i.e

cell A2 =IF(sheet1,G14,0,0)

Cell G2 =IF(sheet2,A2,0,0) - error as it is refering to a specific outcome of sheet 2 A2