View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Harald Staff[_3_] Harald Staff[_3_] is offline
external usenet poster
 
Posts: 4
Default 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.