POWER() and ^ for exponential/compounding/discounting computations
=ROUND(A1/50,0)*50 will yield nearest 50 (multiple of 50) and similar technique can be used to solve for nearest 5, 10, 25 and any such combinations. It is more useful since =MROUND() does not work for +ve and -ve numbers simultaneously.
Get free tutorials, updates, tips and tricks and much more.