
New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey
Edition 1ISBN: 978-0538742917
New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey
Edition 1ISBN: 978-0538742917 Exercise 8
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
Explanation
Using the IF function
In the Excel, the...
New Perspectives on Microsoft Excel 2010 1st Edition by June Jamrich Parsons ,Dan Oja,Roy Ageloff ,Patrick Carey
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255

