Copying output in Excel

vneat - Mar 21, 2010 at 02:16 AM
 vneats - Mar 22, 2010 at 12:26 AM
Hi, I have written a single cell formula in Excel which gives "Pension Amount" depending upon the inputs on "Age" and "Salary" of the pensioner from adjacent cells. Now I want to make a chart of pension amount depending upon age and salary as follows:
Age Salary PensionAmount
35 5000 .......
. . ...
. . ...
53 7500 .........

But copying and pasting the PensionAmount for each category of Age & Salary is proving a very tedious task. Each time I enter a different Age or Salary, the PensionAmount changes and I have to paste it manually in the above chart against the corresponding category.
Could u pls suggest any macro that will automatically "fill up" the "Pension Amount" in the corresponding categories for each Age and Salary.
I tried using "IF" statement as follows: =IF((AND(Age=A1,Salary=B1)),C1)
This fills up the correct PensionAmount for the relevant category of Age/Salary combination in the above chart. But when i run it for another combination of Age/Salary, the PensionAmount for the previous category becomes "False" or 0.
Pls help.

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Mar 21, 2010 at 08:53 PM
problem not clear. you have a formula for calculating pension amount depending on age,and present salary for e.g. the fomula is

suppose your data is like this

age salary
35 20000
37 25000
39 30000
41 35000
43 40000
45 45000
47 50000
49 55000
51 60000

now in c2 type this formula
copy C2 down

one quick way of copying c2 down in excel is
take the cursor to the bottom right when the cursor become a + sign
click this + then c2 will be copied down till data is there in column B
Hello Venkat
While I thank you for your response, my problem is not of copying the pension formula but its output. The pension formula is very complex and not as simple as you have thought it out. It cant be produced here. What I want is to copy its output for different age/salary inputs.