Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

darwen

macrumors 6502a
Original poster
Apr 12, 2005
668
13
California, US
Numbers is frustrating me. The help document for quotient says this:

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?
 
Can't you just use the " / " (divide) function?

And truncate it to two decimals?
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.