Pages

Search

Excel Help Forum - Excel Formulas & Functions: Formula with Different Percentages

Feed2Mail notification - new post on Excel Help Forum - Excel Formulas & Functions
Formula with Different Percentages
I need to create a formula that allows me to multiply one cell by another, but the percentage in the second cell would change based on the number in the first cell. For example – the first 20 participants will pay $10, but if they have 30 participants, the next 10 get 15% off, and the 10...