Perform function...if?

[confused man]

Hi I have a workbook that I'm continually adding data to daily. and I also
have another workbook that I want to perform calculations, but I only want
the calculations performed IF there is data in the first workbook... Here
are the two formulas the way they are now...

='Stock Return Data'!J24*0.25

='Stock Return Data'!J24-'Tax Data'!A14

How can I tell both these functions, to only perform if there is data on the
original worksheet?


Thanks,
Confused Man

 

[Frank Kabel]

Hi
try
=IF('Stock Return Data'!J24<>"",'Stock Return Data'!J24*0.25,"")