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
|