Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Formula to give 5%rise in a figure if it occurs b/wn 2 dates | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do figure excel formula out? | Excel Discussion (Misc queries) |