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
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,098
Messages
5,835,368
Members
430,353
Latest member
GS90

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