At 06:52 22/11/2011 -0600, Wade Smart wrote:
On Tue, Nov 22, 2011 at 02:02, Brian Barker <[email protected]> wrote:
> =SUM(C35:C40)-9*INT(SUM(C35:C40)/10)
Brian, the values of C35 - 40 are (right now)
4,1,5,9,5,3 = 27
2 + 7 = 9
But when I used your function it produces 0
I'm not sure what you are doing wrong, but the formula does work, as
you can see by following it. Using your example, the sum is 27,
which is first divided by 10, giving 2.7. The INT() function then
returns the whole number part of this, which is 2. This is
multiplied by nine, giving 18. Finally, this is subtracted from the
sum (27), giving 9 - exactly what you expect.
If you get zero, you must have entered the formula wrongly or made
some other mistake.
Brian Barker
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
