Here is a simple formula that will do that for you:
=IF(AND(A21),A2+6000)

"Cyclops" wrote:

I have to create a vehicle service record and I wish to have the service
interval of 6000 miles automatically added to the current milage.I wish to do
this horizontally eg.

a b c d e
1 14 6014
2 6020 12020

a = milage at service
e = next service due

Is there a way to write a formula for any number entered in the a column
that adds 6000 and places it in e.Many thanks to anybody who can assist