Cell increase by increasing another cell

[kierons316]

I'm wanting a formula that will increase the value in a cell by 1 when the value of another cell is increased by so much, eg

if a1 = 78, i want b1 = 7

basically i want b7 to tell me how many full 10's there are in a1. so then when a1 gets to 80, b1 will read 8.

there's probably going to be a real simple way of doing what i want but i cant figure it.

I've tried dividing a1 by 10, but it rounds the value up which i dont want.

thanks

 

[VoG]

Try

=INT(A1/10)

 

[mancemonster]

Try...

=ROUNDDOWN(A1/10,0)

 

[kierons316]

Thanks vog & mance, both of those are perfect. and as i said, really simple

thanks again