K
Klee
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
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