Creating a formula
 

Hi,
I'm trying to create a pricing calculator where I can just input the Paper
type and quantity and returns the pricing amount according to the pricing
bracket.
So for example I want to print 16 x 160gsm sheets, I want to formula to
return the amount $4.43 so can then multiply 16 x $4.43, I just don't know
how to achieve this. Below is just an example, the actual spreadsheet has
many more paper types and quantity price brackets.
Product 1 to 3 4 to 10 11 to 25 26 or more sheets
160gsm Paper $6.49 $5.26 $4.43 $3.70
200gsm Paper $6.54 $5.31 $4.48 $3.74
250gsm Paper $6.60 $5.37 $4.53 $3.79
280gsm Paper $6.63 $5.40 $4.56 $3.82

Creating a formula
 

See this screencap:

http://img410.imageshack.us/img410/158/lookupug1.jpg

Biff

"JonathanW" wrote in message
...
Hi,
I'm trying to create a pricing calculator where I can just input the Paper
type and quantity and returns the pricing amount according to the pricing
bracket.
So for example I want to print 16 x 160gsm sheets, I want to formula to
return the amount $4.43 so can then multiply 16 x $4.43, I just don't know
how to achieve this. Below is just an example, the actual spreadsheet has
many more paper types and quantity price brackets.
Product 1 to 3 4 to 10 11 to 25 26 or more sheets
160gsm Paper $6.49 $5.26 $4.43 $3.70
200gsm Paper $6.54 $5.31 $4.48 $3.74
250gsm Paper $6.60 $5.37 $4.53 $3.79
280gsm Paper $6.63 $5.40 $4.56 $3.82