If & and problem?
 

Hi,

Ive got a series of company cars that complete different amounts of miles
each month that I record and track in a spreadsheet, is there a formula that
I could use that could highlight if they are over due or coming up their
services?

Where Im coming un stuck is that over the months their service target will
change as their car increases its mileage, so for example one car might be
coming up for its 12k service but in 3 months it could be up for its 24k
service. Another car may have already done 76k and be coming up on its 84k
service. (All services are every 12 thousand miles). Ive tried using if &
and but keep getting stuck as the cars never finish each month on what a
service target would be.

Many thanks for any advice or direction.
Andy

If & and problem?
 

C2 =IF(B2-A2=12000,"Need service","")

Where A2=12000, B2=24000


"Andy the Yeti" wrote:

Hi,

Ive got a series of company cars that complete different amounts of miles
each month that I record and track in a spreadsheet, is there a formula that
I could use that could highlight if they are over due or coming up their
services?

Where Im coming un stuck is that over the months their service target will
change as their car increases its mileage, so for example one car might be
coming up for its 12k service but in 3 months it could be up for its 24k
service. Another car may have already done 76k and be coming up on its 84k
service. (All services are every 12 thousand miles). Ive tried using if &
and but keep getting stuck as the cars never finish each month on what a
service target would be.

Many thanks for any advice or direction.
Andy