Can prices be rounded to the nearest 99 cents? (i.e. 4.33 to 4.99, or 5.53 to 5.99). I can get to the neares .09 with "=ROUND(A1,1)-0.01", but this function may be too simple for .99 rounding. Thanks in advance.
Can prices be rounded to the nearest 99 cents? (i.e. 4.33 to 4.99, or 5.53 to 5.99). I can get to the neares .09 with "=ROUND(A1,1)-0.01", but this function may be too simple for .99 rounding. Thanks in advance.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks