Formula meets a requirement

[FAUZAN]

Hello there, please Help me to find the formula. Here's my data

Jan Feb Mar Apr May Jun
67000 67436 70605 73422 76239 80000

My Data from Column A to F. Every 5000 numbers I want a formula that notified me in Column G something like "Apr & Jun need maintenance".

Thank's

 

[Robert Mika]

What do you mean "by 5000" numbers?

 

[FAUZAN]

What do you mean "by 5000" numbers?

I'm sorry, I should write every 5000 Km's. this data to show in what month's car needed to be service. Thank's for your attention.

 

[Robert Mika]

Hi sorry for not getting bacj erier.
IS that per 5000k in each cell on two or more cell combained?
Looing at your data this probably shoudl be "Apr, May and June need maintenance"

 

[FAUZAN]

Hi sorry for not getting bacj erier.
IS that per 5000k in each cell on two or more cell combained?
Looing at your data this probably shoudl be "Apr, May and June need maintenance"

Thank's for reply, It's 5000K from the beginning of year. Data are the state of the 1st day in every month. Column A1:L1 are names oh month. A2:L2

67,000.00 67,436.00 70,605.00 73,422.00 76,239.00 80,000.00 82,000.00 86,000.00 90,000.00 92,000.00 100,000.00 104,000.00

This is my non effective formula to solve the problem... but still expect the shortest formula and maybe just placed in a cell the result whether to service it or no.

I've made formula start to check Feb vs Jan in N2. =ROUND((B2-$A$2)/5000,0). then copy paste them until column X. so the results - 1.00 1.00 2.00 3.00 3.00 4.00 5.00 5.00 7.00 7.00
And I made another helping formula in Z2 to check the status of Feb =IF(N2=M2,"OK","Service") the results are OK Service OK Service Service OK Service Service OK Service OK

once again. thank's for your attention. still need the effectives formula than my consumed much column formula.

 

[Robert Mika]

Maybe I'm wrong but the service should be done at 72000,77000,82000 and so on or every 5000 -70000, 75000, 80000 in your case you have in both 80000 and 82000 is that what you need?