Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts or Grids
Hi there,
I'm trying to fill in a grid with information from another spreadsheet. The grid looks like this: 20 25 30 35 40 45 50.....ect 2 3 4 5 The numbers across the top are volume and down the side are different prices. I have created a table already to show the revenue using a formula to multiply volume times price. Now I can see that if I sell 50 pencils at $2 per I will make $100. Easy right? The problem is that I need to do one that calculates my gain/loss based on a different spreadsheet. The spreadsheet shows that if I sell $50 at $2 each I will generate $100 profit and that my cost of sales will be $x and my general overhead will be X. These numbers change constantly based on what volume and price I enter. I would like to generate a table showing what my loss/gain would be based on all of these variables without having to type then in separately? Is there any way to do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Contour Plot Grids | Charts and Charting in Excel | |||
type a sentence so it extends over grids | Excel Discussion (Misc queries) | |||
Grids | Excel Discussion (Misc queries) | |||
Grids | Excel Worksheet Functions | |||
Removing grids | Excel Discussion (Misc queries) |