"akelogorian" wrote in message
...
Tom, I understand what you are saying, but, that being the case why did
the
"$10" calc not display "1" (rounding $8.73 up to "$10" first)?

8.73 rounds to 9. Here are the steps:

$50: [Nett Weekly Pay]\50 178.73 rounds to 179 == 179 \ 50 = 3

$20: ([Nett Weekly Pay]-([$50]*50))\20

(178.73 - 3 * 50) = 28.73 which rounds to 29 == 29 \ 20 = 1

$10: (([Nett Weekly Pay]-([$50]*50)-([$20]*20))\10)

(178.73 - 3 * 50 - 1 * 20) = 8.73 which rounds to 9 == 9 \ 10 = 0

$5: (([Nett Weekly Pay]-([$50]*50)-([$20]*20)-([$10]*10))\5)

(178.83 - 3 * 50 - 1 * 20 - 0 * 10) = 8.73 which rounds to 9 == 9 \ 5 = 1

$2: (([Nett Weekly Pay]-([$50]*50)-([$20]*20)-([$10]*10)-([$5]*5))\2),

(178.83 - 3 * 50 - 1 * 20 - 0 * 10 - 1 * 5) = 3.73 which rounds to 4 == 4 \
2 = 2

Tom Lake