Re: Why it doesn't work for 5 American Dollars
I think that the problem is the way you have created the nested IFs. If the value in R11 is greater than 12, only the first IF is executed, so you would get R11-12, even if R11 > 36, it will not get to that portion of the nested IF statement. Once the first TRUE condition is encountered, it will not keep processing. Maybe try to change the order around to check for the greatest value first. Maybe the MOD function proposed does what you want. You could also make it look a lot more complicated with AND conditions like IF(AND(R11>12, R11<24),R-11...