# IF function

#### Murraya

##### New Member
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

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
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.

Replies
2
Views
560
Replies
1
Views
219
Replies
1
Views
2K
Replies
5
Views
403
Replies
21
Views
1K

1,218,922
Messages
6,145,235
Members
450,603
Latest member
jpbegley

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back