The IF function is quite powerful as a standalone function. However, when combined with AND/OR functions, it becomes much ...