Forum Discussion
IFS function + roundup, sum, and right
I can't get less than and more than to work how I'd like it to in an IFS function. =IFS((RIGHT(ROUNDUP(SUM(((G6*0.55)+G6)+((G6*0.55)+G6)/11),2),4))<=5,CEILING(SUM(((G6*0.55)+G6)+((G6*0.55)+G6)/11)...
.. or if you want to name the coins
= CEILING(amount, nickel) - (MOD(amount, dime)>nickel)*penny
Interestingly an exact number of dollars will go down 1 cent to the 99 cents below. This is due to rounding error caused by the fact that decimal coinage does not have an exact representation in binary arithmetic.