Mail Merge with Excel File

XYZ COMPANY recently concluded a recruitment exercise to selected positions. You were given the list as an HR officer to send an appointment letter to all the successful applicants’ email address. The letter must be addressed to an individual with following details from Microsoft Excel file. What comes into your mind in this situation, are[…]

Shares 0

Combining IF with AND & OR

In this post, i will take you through how to combine IF function with other functions like OR and AND functions. IF with AND Combining AND function with IF function’s logical expression will ask Excel to returns TRUE if all conditions are met and FALSE if otherwise. This assertion is demonstrated in the screenshot below IF(AND(C4>=18,D4=”YES“),”Eligible to[…]

Shares 0

Basic of IF function

IF function is one of the most useful function in Excel and the trick behind the function is to instructs Excel to test for a condition and return a value if the supplied condition is met (TRUE) or return another value if otherwise (FALSE). Syntax: IF(logical_test, [value_if_true], [value_if_false]) Logical_test: this a logical expression that can[…]

Shares 0