I am working on a wage study. I need it to be formulated like so:
If more than 2 decimal places, round up to nearest hundredth. Regardless of the value of the 3rd decimal, it needs to be rounded.
i.e. 3.411>>>>>3.42 or 3.416>>>>>3.42
If there are only 2 decimal places, no rounding.
3.41>>>>>>3.41 or 3.410000>>>>>>3.41
Help!
Thanks.
Bookmarks