Rounding
Round seems to round only to whole numbers. I would like to be able to round to a certain number of decimal places. For example, rounding to two places for money calculations. How about:
Places(3.7823323,2) gives 3.78 or something of that nature.
Another idea would be a "setting" that specifies output format and places.
-
Great feedback. If you add a dollar sign ($) anywhere it will auto-round to two decimal places (so $sales = 13.3434 * 342.423 will be rounded to 2 decimal places). There isn't a way to round to other places, but I was thinking of something like having "###" in a cell to indicate you want 3 decimal places.