alkhafajialaa
New Member
- Joined
- Sep 29, 2011
- Messages
- 1
I am having a little bit of an issue. I have a profit equation
=Ticket_price*Number_of_spectators+Number_of_spectators*Average_concession*Concession_percentage_margin+Number_of_spectators*Purchasing_spectators*Average_purchase*Souvenir_gross_margin-(Total_fixed_costs+CEILING(Number_of_spectators/Variability_rate__spectators,1)*Security_guard*Race_days+IF(Number_of_spectators>Variability_rate__spectators,(Number_of_spectators-Variability_rate__spectators)*Additional_cleanup*Race_days,0))
This equation gives me profit. What I need to do is find Number of spectators when profit equals 0. All I need to do is solve for number of spectators! I am having a problem because of the if and Ceiling statements. PLEASE HELP!!
=Ticket_price*Number_of_spectators+Number_of_spectators*Average_concession*Concession_percentage_margin+Number_of_spectators*Purchasing_spectators*Average_purchase*Souvenir_gross_margin-(Total_fixed_costs+CEILING(Number_of_spectators/Variability_rate__spectators,1)*Security_guard*Race_days+IF(Number_of_spectators>Variability_rate__spectators,(Number_of_spectators-Variability_rate__spectators)*Additional_cleanup*Race_days,0))
This equation gives me profit. What I need to do is find Number of spectators when profit equals 0. All I need to do is solve for number of spectators! I am having a problem because of the if and Ceiling statements. PLEASE HELP!!
