Infinite IF function?

[atarikick]

Hi

I'm trying to use IF and AND functions to create a basic input-output system. The problem I have (more details below) is the 64 limit when the potential inputs could be infinite. I'm almost certain I'm using the wrong function to solve the problem, so any advice would be really appreciated.

Problem;

For values entered into a cell between 1 and 10, this should produce an output of 0.00 in another
A value higher than 10 should output as 1.00, and from then an extra 1.00 is added for every '10' added.
There is no limit on the input

ie 1 = 0.00, 11 = 1.00, 29 = 2.00 and so on.

I apologise if it's not too clear, thanks a lot

[DonkeyOte]

So perhaps you mean ?

B1:
=INT((A1-1)/10)

where A1 is value.

Note above assumes whole numbers.

[atarikick]

Looks like I do, I thought I was making it far too complicated by going the IF route

Thankyou very much