06.05.2012, 08:13
I myself do not know much about Excel!
but if you write your numbers beginning with 110.96 in the first cell A1 until A3000 in the first column, then in the first cell (B1) in the second column, type 1500 then select that cell (right-click with your mouse, highlight it with a dashed line around it in the pop up menu, select copy and copy its contents (number 1500), then select the rest of the second column down until the B3000 and then right click the mouse again and choose past, now the second column contains 3000 times numeral 1500 straight downward.
Now put the mouse in cell A1 and select until the C1 and then pull down to the C3000, now you have three columns marked, it's just pressing the auto sum button (the big button with sigma sign on it) and the sum of the first and second column's cells
will appear in the C1 until C3000, now you can copy an past the third column in your mission file.
I think there must be even easier way for this by writing a formula up there, but I do not know which formula!
but if you write your numbers beginning with 110.96 in the first cell A1 until A3000 in the first column, then in the first cell (B1) in the second column, type 1500 then select that cell (right-click with your mouse, highlight it with a dashed line around it in the pop up menu, select copy and copy its contents (number 1500), then select the rest of the second column down until the B3000 and then right click the mouse again and choose past, now the second column contains 3000 times numeral 1500 straight downward.
Now put the mouse in cell A1 and select until the C1 and then pull down to the C3000, now you have three columns marked, it's just pressing the auto sum button (the big button with sigma sign on it) and the sum of the first and second column's cells
will appear in the C1 until C3000, now you can copy an past the third column in your mission file.
I think there must be even easier way for this by writing a formula up there, but I do not know which formula!
Code:
A B C
1 110,96 1500 1610,96
2 88,92 1500 1588,92
3 2,86 1500 1502,86
4 2,80 1500 1502,8
5 2,72 1500 1502,72