Conditional Pricing Formula

[afrobea_r]

Dear Excel Wizards,

Current Scenario

Product Price : $50
Quantity : 10
Revenue : $50*10 = $500

However, how do I create a separate row denoting a promotion that shows that the buyer is only paying for 9 quantities for every 10 purchased. This will increase across the columns based on incremental quantities. Basically, would like to observe a matrix.

Help much appreciated, thank you!!

Best Regards,
abear

 

[steve the fish]

This perhaps:

=A1*(A2-INT(A2/10))

 

[afrobea_r]

This perhaps:

=A1*(A2-INT(A2/10))

Thank you very much Sir