Hi!

You'd have to format the cells where you enter the page size as a FRACTION
(up to one digit)

Then:

=IF(B2=0,"",LOOKUP(B2,{0.125,550;0.25,800;0.5,1000 ;1,1500})*IF(OR(B1={"Sept","Oct","NOV"}),1.25,1))

Biff

"gravity003" wrote in message
...
I need to set up a spreadsheet showing the different rates for parts of a
page.

Rates 1/8 page=$550, 1/4 page=$800, 1/2page=$1,000 and full page=$1500
with
a 25% premium for the months of Sept, Oct, and Nov.


I want to be able in insert the page fraction purchased and in a column
below give me the dollars amount?

Spreadsheet would look like this?

Vendor Name Jan Feb March April May June Ect
XYZ 1/8 1/4 1 0 0 0

550 800 1500 0 0 0