Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Added Table
Hello, I have a spreadsheet that contains numerous formulas and when one
number, say revenue is changed, then I get a calculated number, say surplus at the end of the spreadsheet. I would like to add a table that lets the Revenue start at one value, then increase by $2,500 as you go down the table. The next column of the table will be the surplus value if the revenue is this particular value that is entered in the cell to the left. Am I making sense? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Added Table
Doesn't make much sense to me - perhaps you can re-phrase your
description of what you want to achieve (and what you have already). Pete On Apr 5, 5:18*pm, Steve of Atlanta <Steve of wrote: Hello, I have a spreadsheet that contains numerous formulas and when one number, say revenue is changed, then I get a calculated number, say surplus at the end of the spreadsheet. *I would like to add a table that lets the Revenue start at one value, then increase by $2,500 as you go down the table. *The next column of the table will be the surplus value if the revenue is this particular value that is entered in the cell to the left. *Am I making sense? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Added Table
I have been thinking about this some more. My revenue cell is a variable
cell. It can range from say $50K to $75K. I would like to have a table with one column with revenue starting at $50K, the cell below it would be $52,500, the cell below it would be $55,000 and so on up to $75K. In the next column over, I would like this to be the surplus column. Let's say if my revenue is $50K, my surplus will be $10K, according to my existing spreadsheet. If I plug in $52,500, then it will give me a surplus of $12K. I would like the table to summarize this. The revenue would be a variable in other words, then with each variable amount, the surplus would display right beside it. Is that possible? "Pete_UK" wrote: Doesn't make much sense to me - perhaps you can re-phrase your description of what you want to achieve (and what you have already). Pete On Apr 5, 5:18 pm, Steve of Atlanta <Steve of wrote: Hello, I have a spreadsheet that contains numerous formulas and when one number, say revenue is changed, then I get a calculated number, say surplus at the end of the spreadsheet. I would like to add a table that lets the Revenue start at one value, then increase by $2,500 as you go down the table. The next column of the table will be the surplus value if the revenue is this particular value that is entered in the cell to the left. Am I making sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a lookup table with an added varable? | Excel Worksheet Functions | |||
Pivot Table with Data Added Monthly | Excel Discussion (Misc queries) | |||
Insert rows in linked table that are added to secondary table | Excel Discussion (Misc queries) | |||
Added new columns - Pivot Table not refreshing - why? | Excel Worksheet Functions | |||
"." & a "+" added 2 a table reformatd as text in Word??? | Excel Worksheet Functions |