Related:

- Copying output in Excel
- Number to words in excel - Guide
- Ps4 audio output - Guide
- How to take screenshot in excel - Guide
- Dd-mm-yyyy format in excel - Guide
- Excel free download - Download - Spreadsheets

## 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

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

=salaray*age/60

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

=B2*A2/60

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

=salaray*age/60

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

=B2*A2/60

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

Mar 22, 2010 at 12:26 AM

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.

Thanks