i feel really incompetent here. i cant come up with a solution that rounds any number UP to the nearest .25.
Right now, let num be my number (a currency value) that I want to round up to the nearest quarter to yield result...no matter how much closer it is to the lower quarter. For example, 1.80 needs to be 2.00, not 1.75.
Right now, my equation rounds up & down
num/25 = mid
truncate mid to only two decimal places
mid*25 = result
does anyone have a good idea how to tweak this to always round up?
im thinking I need to add something to num or maybe multiply by 100 first to make it an integer, and then divide later to get it back to decimals...but nothing is working out for me.
Thanks in advance.