formula: If cell is divisible by 10, then TRUE.. how to set it up?

[cat3appr]

Hello,

I have this column A of numbers, I need to create a formula which will place, in column B, a sequential number multiple of 10 each time it finds a cell in column A that contains a number which is divisible by 10, ex:

at A15 - 1.20 it places a 10 in B15 at A25 - 1.30 it places a 20 in B25 at 1.40 it places a 30 and so on ... please refer to the attached .xls and screenshot.
thank you!

[shg]

How are 10, 30 and 40 sequential multiples of 10?

[KOKOSEK]

Into B2:

Please Login or Register  to view this content.

and drag it down as needed.

[Melvosh]

Another option:

Please Login or Register  to view this content.

[modytrane]

one more:
In B3:

Drag it down.

[cat3appr]

Into B2:

Please Login or Register  to view this content.

and drag it down as needed.

Thanks a lot! it worked but... it keeps on repeating the same integer, 20 ...
I had to apply the formula in another spreadhseet with all the other data, so I modified it substituting A2 with Q2 but I don't think this was an issue?

=IF(AND(Q2<>"",ISNUMBER(Q2)),IF(Q2=ROUND(Q2,1),MAX($Q$1:Q1)+10,""),"")

I've included the original .xls , if you manage to have the formula working on lolumn R, so that by dragging down I'll get 10,20,30 and not 20,20,20

many thanks!

[Melvosh]

A slightly modified version of the formula in post #4:

Please Login or Register  to view this content.

Edit: the modified version of KOKOSEK's formula from post #3 should be:

Please Login or Register  to view this content.

I believe either will work.

[cat3appr]

yes thanks a lot, super, i appreciate it!

[KOKOSEK]

Cheers @Melvosh.
You welcome @car3appr.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.