Good morning
I am creating a spreadsheet that needs the following and I'm having trouble creating this formula.
I earn commission and I am charged a specific percentage of my sales until I reach a specific sales volume number , say 15% and charged a different percentage once I reach another total sales volume, say 10%.
For example, once the values of cells H5 to H33 reaches $50,000, I am charged 10% but for anything below $50,000, I'm charged 15%. To complicate matters, I'm still charged the 15% on the first $50,000.
Any thoughts?
Thanks
Craig
I am creating a spreadsheet that needs the following and I'm having trouble creating this formula.
I earn commission and I am charged a specific percentage of my sales until I reach a specific sales volume number , say 15% and charged a different percentage once I reach another total sales volume, say 10%.
For example, once the values of cells H5 to H33 reaches $50,000, I am charged 10% but for anything below $50,000, I'm charged 15%. To complicate matters, I'm still charged the 15% on the first $50,000.
Any thoughts?
Thanks
Craig