excel maths
 

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

excel maths
 

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

excel maths
 

=A1+6000
--
David Biddulph

"Cyclops" wrote in message
...
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

excel maths
 

What does the AND function do in that formula?
--
David Biddulph

"Pokey" wrote in message
...
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

excel maths
 

David Biddulph wrote:
What does the AND function do in that formula?
--
David Biddulph

"Pokey" wrote in message
...
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



To answer David's question, it puts FALSE in column E when column A is
empty. If you copy the formula down in column E you'll get FALSE entered
until you enter numbers1 in column A. If you copy down =A2+6000 you'll
see 6000 entered in column E when column A is blank.

I'd suggest =IF(A2="","",A2+6000) entered in E2, which will leave column
E blank unless a value is entered in column A when the formula is copied
down.

Bill

excel maths
 

It's not the AND function that gives the FALSE result, Bill; it's the
absence of an argument as the alternative result.
The AND function does nothing, as far as I can see.
=IF(AND(A21),A2+6000) does the same as =IF(A21,A2+6000)
--
David Biddulph

"Bill Sharpe" wrote in message
...
David Biddulph wrote:
What does the AND function do in that formula?
--
David Biddulph

"Pokey" wrote in message
...
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



To answer David's question, it puts FALSE in column E when column A is
empty. If you copy the formula down in column E you'll get FALSE entered
until you enter numbers1 in column A. If you copy down =A2+6000 you'll
see 6000 entered in column E when column A is blank.

I'd suggest =IF(A2="","",A2+6000) entered in E2, which will leave column E
blank unless a value is entered in column A when the formula is copied
down.

Bill

excel maths
 

Many Thanks Bill.Works just how I require it.

"David Biddulph" wrote:

It's not the AND function that gives the FALSE result, Bill; it's the
absence of an argument as the alternative result.
The AND function does nothing, as far as I can see.
=IF(AND(A21),A2+6000) does the same as =IF(A21,A2+6000)
--
David Biddulph

"Bill Sharpe" wrote in message
...
David Biddulph wrote:
What does the AND function do in that formula?
--
David Biddulph

"Pokey" wrote in message
...
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



To answer David's question, it puts FALSE in column E when column A is
empty. If you copy the formula down in column E you'll get FALSE entered
until you enter numbers1 in column A. If you copy down =A2+6000 you'll
see 6000 entered in column E when column A is blank.

I'd suggest =IF(A2="","",A2+6000) entered in E2, which will leave column E
blank unless a value is entered in column A when the formula is copied
down.

Bill


.

excel maths
 

David Biddulph wrote:
It's not the AND function that gives the FALSE result, Bill; it's the
absence of an argument as the alternative result.
The AND function does nothing, as far as I can see.
=IF(AND(A21),A2+6000) does the same as =IF(A21,A2+6000)
--
David Biddulph
My only exercise appears to be jumping to conclusions. You're right, the
IF function requires two choices.

Bill