Hi,
I am trying to construct a spreadsheet that calculates what notes/coin to give as change.
Under a specific set of calculations, even though both INT and TRUNC functions return a "1" result, when nested into an IF function they return a zero.
In the last entry line of the attached workbook, everything is fine until you enter $500 as the amount tendered. The formula in cell O4 then falls over and I get a zero result, even though the nested TRUNC function has a result of 1.
What am I doing wrong?
Regards,
Gary
Bookmarks