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

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?

MIKE

Ask Your Question

Weekly Poll

Do you think ride and car sharing are the future of transportation?

Discuss in The Lounge

Poll History