IF function

Murraya

New Member
Joined
Sep 15, 2002
Messages
1
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
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,511
Messages
5,596,581
Members
414,079
Latest member
Frills

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top