New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey

تمرين 15

If an Excel worksheet stores the cost per meal in cell Q5, the number of attendees in cell Q6, and the total cost of meals in cell Q7, what IF function would you enter in cell Q7 to calculate the total cost of meals (cost per meal times the number of attendees) with a minimum cost of $10,000