Ask Experts Questions for FREE Help !
Ask
    wijesekera's Avatar
    wijesekera Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Oct 17, 2010, 08:25 AM
    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.
    atr4ug's Avatar
    atr4ug Posts: 12, Reputation: 1
    New Member
    		  
    #2

    Jan 9, 2011, 10:54 PM
    TRY TO USE IF LOGIC
    =IF(A1=0,"",IF(A1="",""))
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Word & Excel Mail Merge [ 4 Answers ]

When I obtain a number from an Excel database to insert it in a Word document, how can I edit that number on Word??

Merge cells in multiple fields in excel [ 2 Answers ]

How to merge multiple cell in excel file

Mail merge [ 1 Answers ]

How do you obtain mail merge?

Excel - Merge Cells [ 3 Answers ]

Any way to merge a number of cells into one cell, for example the title of many columns in a table?

View more questions Search