Excel Rounding?
Use the round function. For details on the syntax look up "round function" in the help menu/office assistant. Here's how to do the formula you referenced. =round((I6-(I6*$J$5))*20,0)/20 It multiplies by 20, then rounds the result to the nearest ones digit...