# Excel exercises on CONDITIONAL FORMULAE

 Software: Excel Version: Excel 2010 and later Topic: Conditional formulae Level: Relatively easy Courses: Excel Business ModellingExcel Intermediate Exercise: Use IF functions in Microsoft Excel 2007 to rate movies as a flop or success based on their profit.
 Software: Excel Version: Excel 2010 and later Topic: Conditional formulae Level: Relatively easy Courses: Excel Business ModellingExcel Intermediate Exercise: Use an If function in Microsoft Excel 2007 to rate the players in a game of poohsticks.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Relatively easy Courses: Excel Business ModellingExcel Intermediate Exercise: Single IF simple to calculate engineer callout charge at 2 different rates.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Relatively easy Courses: Excel Business ModellingExcel Intermediate Exercise: Using If to display different size text messages.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Relatively easy Courses: Excel Business ModellingExcel Intermediate Exercise: Uses single =IF.
 Software: Excel Version: Excel 2010 and later Topic: Conditional formulae Level: Average difficulty Courses: Excel Business ModellingExcel Intermediate Exercise: Use an If function in Microsoft Excel 2007 to calculate total values based on different charge rates.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Average difficulty Courses: Excel Business ModellingExcel Intermediate Exercise: Calculate conditional counts and sums of data using Excel functions.
 Software: Excel Version: Excel 2010 and later Topic: Conditional formulae Level: Average difficulty Courses: Excel Business ModellingExcel Intermediate Exercise: Use an If function in Microsoft Excel 2007 to calculate a bonus based on whether targets have been met.
 Software: Excel Version: Excel 2010 and later Topic: Conditional formulae Level: Average difficulty Courses: Excel Business ModellingExcel Intermediate Exercise: Pracises using nested =IF to decide on the fine a player gets.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Average difficulty Courses: Excel Business ModellingExcel Intermediate Exercise: Calculate parking fees using an IF function.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Average difficulty Courses: Excel Business ModellingExcel Intermediate Exercise: If functions to calculate different order discounts.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Average difficulty Courses: Excel Business ModellingExcel Intermediate Exercise: Using IF to calculate different voucher rates.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Average difficulty Courses: Excel Business ModellingExcel Intermediate Exercise: Using If to Calculate different parking charges.
 Software: Excel Version: Excel 2010 and later Topic: Conditional formulae Level: Average difficulty Courses: Excel Business ModellingExcel Intermediate Exercise: Use an If function in Microsoft Excel 2007 to calculate different order totals based on the quantity of items ordered.
 Software: Excel Version: Excel 2016 and later Topic: Conditional formulae Level: Harder than average Courses: Excel Business ModellingExcel Intermediate Exercise: Using =IF and Concatenation to display different text messages.
 Software: Excel Version: Excel 2010 and later Topic: Conditional formulae Level: Harder than average Courses: Excel Business ModellingExcel Intermediate Exercise: Use a nested If function in Microsoft Excel 2007 to translate codes into full text descriptions.
 Software: Excel Version: Excel 2010 and later Topic: Conditional formulae Level: Harder than average Courses: Excel Business ModellingExcel Intermediate Exercise: Create nested If functions in Microsoft Excel 2007 to categorise lists of data.

You can search our full list of Excel exercises here, or why not have a look at our other Excel training resources?