Hi
I am trying to do a bank analyses by working out the number of coin
denominations in a salary.
The formula works fine except for 80 cents.

I am using the following code
+INT((Q7-(J7*50)-(K7*20))/10)
where Q7=80, j7=1 and K7=1
With INT in place the result=0 and without INT the result = 1

The Function INT should drop the decimal part of a number but in this case
the results is 0.
Any suggestions
Charles