Formulae Question

Hello guys - i'm a bit of a novice when it comes to Excel but would really appreciate some help with pricing up our commodity. When someone buys 750,000 or 1,000,000 or 3,000,000 etc items we charge in a specific way. The first 500,000 are charged at 1%, the second 500,000 are charged at 0.75%, the next million at 0.5%, the next million at 0.25% and so on an so on

What i'd like to be able to do is to just put one number in and it automatically breaks it all down and charges the correct price at the end.

Is that possible at all ?

Much thanks

Welcome to the forum.

Practically everyone here has a formula question: please update your thread title to say explicitly what you want to do with yours. Thanks.

No help to be offered until this is done.

I would if i knew how Ali and i have no idea what title to use either.

Clearly you do know what title to use!

This thread is now closed in favour of your duplicate thread here: https://www.excelguru.ca/forums/sho...odity-using-formulae-within-Excel-Spreadsheet