ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Add a set number to a random entered number (https://www.excelbanter.com/excel-discussion-misc-queries/252428-add-set-number-random-entered-number.html)

Cyclops

Add a set number to a random entered number
 
I have to start a vehicle service record and am trying to add the 6000 mile
service interval to the mileage at service number.
EG.
A B C D
1 6000 12000

2 12125 18125

3 18200 24200 etc

A is the mileage at service and C is the next service due.I am trying to do
this without having a cell with a line of 6000 in it and the formula eg
=SUM(A1:B1) in the C cell.Is this possable?Hope some one can help.

Harald Staff[_3_]

Add a set number to a random entered number
 
Hi

=A1+6000

HTH. Best wishes Harald

"Cyclops" skrev i melding
...
I have to start a vehicle service record and am trying to add the 6000 mile
service interval to the mileage at service number.
EG.
A B C D
1 6000 12000

2 12125 18125

3 18200 24200 etc

A is the mileage at service and C is the next service due.I am trying to
do
this without having a cell with a line of 6000 in it and the formula eg
=SUM(A1:B1) in the C cell.Is this possable?Hope some one can help.





All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com