I use this function to issue a letter to employees detailing their salary earnings & deductions. Problem is that all the fields (including unwanted fields)in excel workshhet appears in pay advice.(eg. "loan installement" print in pay advice as zero,for those who not obatained loans also.) .I tried " skip record if " rule to overcome this but failed. Help me please.

TRY TO USE IF LOGIC
=IF(A1=0,"",IF(A1="",""))