IF function

[Murraya]

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

 

[PaddyD]

Hi - welcome to the board!

"Create a spreadsheet..." leads me to believe this is homework / coursework or similar! Not really keen on providing complete answers to that sort of thing, so may be this will help...

What you will need is a way of relating ranges of CD's bought to the unit prices for those ranges. In general, the vlookup() function is the one to use for that sort of thing. Take a look in the help file, search this board for some examples...


Then, try & apply it to your situation. Please post back with any problems you get & we'll help work through them one by one.

Paddy