Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Word Processing (https://www.askmehelpdesk.com/forumdisplay.php?f=397)
-   -   How to use excel 2007 & mail merge to generate pay advice for employees. (https://www.askmehelpdesk.com/showthread.php?t=517534)

  • Oct 17, 2010, 08:25 AM
    wijesekera
    How to use excel 2007 & mail merge to generate pay advice for employees.
    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.
  • Jan 9, 2011, 10:54 PM
    atr4ug
    TRY TO USE IF LOGIC
    =IF(A1=0,"",IF(A1="",""))

  • All times are GMT -7. The time now is 06:00 AM.