Numbers is frustrating me. The help document for quotient says this:
Thats great and all, except the remainder is important to me. I need to add up dollar amounts and the change is important. How do I get it to keep the remainder?
The QUOTIENT function finds the integer quotient of two numbers, that is, the whole part of the quotient with the fractional part (or remainder) truncated.
QUOTIENT(dividend, divisor)
dividend: The number you want to divide.
divisor: The number you want to divide by.
Thats great and all, except the remainder is important to me. I need to add up dollar amounts and the change is important. How do I get it to keep the remainder?