Excel Tip: Using the IF and AND Functions for Multiple Conditions

This video shows how to use the IF and AND lookup and reference functions to age accounts receivable and accounts payable invoices. There are multiple conditions, as the final result must be between two dates in order for the invoice amount to fall within the correct aging bucket. Excel returns TRUE if all the conditions are met, otherwise FALSE; i.e. any amount greater than zero that appears in an aging bucket is TRUE, otherwise it is FALSE.

Hopefully I explained this in a way that it can be easily understood.

If you wish you can download the original Excel file @http://bit.ly/1VceuuM