View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
gravity003
 
Posts: n/a
Default Formula to figure ad schedules

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