calculate a cap on paymetns

March 4, 2013 at 16:03:57
Specs: Windows 7
a person enters into a number of events at a swimming competition. Each one costs 13.50 to a maximum of $50. So 1 event 13.50, 2 events $27.00, 3 events $40.50 and 4 or more $50. What formula do I need to calculate the cap so far i have =IF(O11=4,50,O11*13.5) but i dont know how to make it stop at 50. Help please

See More: calculate a cap on paymetns

Report •

March 4, 2013 at 17:14:45
This appears to be homework, so I'll give you a hint:

You wrote out: 4 or more $50

How does that translate in your formula?


Report •
Related Solutions

Ask Question