Use the IF function combined in one cell more than seven times. Use the TYPE function to check for invalid values. Use the INT function with the IF function. Use the IF function to calculate the commissions for individual sales Use the IF function to compare two cells. Use the IF function to calculate with different tax rates. Use the IF function to check cells in worksheets and workbooks. Use the IF function to determine the quarter of a year. Use the IF function to compare columns and return a specific result Use the IF function to check for larger, equivalent, or smaller values Combine IF with AND to check several conditions. Use the OR function to check cells for numbers. Use the OR function to check cells for text. Use the AND function to show sales for a specific period of time. 39 Use the AND function to compare two columns. 34Ĭalculate percentage of price reduction. 31 Calculate manpower required for a project. 30 Determine how many pieces to put in a box. 28 Calculate number of hours between two dates. 23 Convert liters to barrels, gallons, quarts, and pints. 22 Convert feet per minute to meters per second. 21 Convert miles per hour to km per hour. 7 Calculate your ideal and recommended weight.