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