Any help is appreciated. Please take a look at the solver contraints I've entered.
The steps that Im having trouble with are below:
13: Load the Solver add-in if it is not already loaded. In cell C34 of the Budget worksheet, use Solver to find the highest balance possible by changing the number of attendees and the ticket price per person. Using the Limitations section of the spreadsheet model, add the following constraints:
Number of attendees
Ticket price per person (this will require two constraints based on the minimum and maximum ticket prices)
Keep the Solver dialog box open.
14: Add the following constraints to the Solver Parameters:
Valet parking expense (less than or equal to the product of the number of parking stalls and the valet price per vehicle)
Use the number of attendees as the integer constraint
Solve the problem, but keep the original values in the Budget worksheet. Create an Answer report.
These are the Contraints that I've come up with but are not correct.
$B$26<=240*19.95
$B$4<=500
$B$4= Integer
$B$9<=100
$B$9>=50