math & trig

In Australia we did away with 1 and 2 cent coins years ago. So all prices, where paid in cash, are rounded down to the nearest value divisible by 5 cents. In Excel we can use the FLOOR function to calculate this value. For example: Say our price is $4.32 and we need to round …

Excel’s RAND and RANDBETWEEN functions aren’t very well known, but they can be quite handy. RAND Function RAND is a simple function that returns a random number between 0 and 1. It is entered =RAND() That’s it…simple. RANDBETWEEN Function RANDBETWEEN is slightly more complicated. =RANDBETWEEN(bottom,top) Where ‘bottom’ is the lowest number you want returned and …

It’s common practice in Excel to format decimal places to get the desired rounding of numbers.  But the problem with this approach is it can display totals that don’t appear to add up correctly. Take the screen shot below that shows 2+2+3=8.  That’s because the underlying numbers are actually 2.4+2.4+3.2. Excel ROUND Formulas The solution …