When you are working with data that involves money and finances, you often need to round amounts to a specific point such as a dollar or perhaps even a half dollar. The tried and true method has always been to use the ROUND function with a formula like the one below: =ROUND(A26/0.5,0)*0.5 The formula divides the value in A26 by half a dollar (0.5) and then rounds it to zero decimal places. The...
No comments:
Post a Comment