Please can someone help with the formula for
this question.
Thanks
The purchase price per CD depends upon the number of CD's purchased. The unit price of each CD depends on the following ranges of the number of CD's purchased:
Total number of CD's purchased is 300 or greater, unit price is $12.75
Total number of CD's purchased is 100 or up to 300, unit price is $15.20
Total number of CD's purchased is 50 or up to 100, unit price is $19.10
Total number of CD's purchased is less than 50, unit price is $25
Create a spreadsheet that uses appropriate functions to calculate the unit price of CD's when the number of CD's purchased is entered by a spreadsheet user.
CD's purchased in cell B14
The unit price should appear in cell B15
this question.
Thanks
The purchase price per CD depends upon the number of CD's purchased. The unit price of each CD depends on the following ranges of the number of CD's purchased:
Total number of CD's purchased is 300 or greater, unit price is $12.75
Total number of CD's purchased is 100 or up to 300, unit price is $15.20
Total number of CD's purchased is 50 or up to 100, unit price is $19.10
Total number of CD's purchased is less than 50, unit price is $25
Create a spreadsheet that uses appropriate functions to calculate the unit price of CD's when the number of CD's purchased is entered by a spreadsheet user.
CD's purchased in cell B14
The unit price should appear in cell B15