Hello,

I'm trying to create a price worksheet.

An album has a base price. Additional pages can be ordered. If a client orders 2 albums, the second one (including any additional pages ordered) will be 15% off. If they order 3 or more, any additional albums (after the first 2) will be 25% off (including any additional pages ordered).

I'd like to enter the number of albums ordered and the number of additional pages and have the above calculated.

Any help would be appreciated!

Thanks.

Excel Question.jpg