Round to .99?

W

WBTKbeezy

Hello, does anyone know if a function will work so that I can round a number
UP to the nearest ending of .99? So if a number is 7.60 it would round to
7.99 or if a number is 7.01 it would round to 7.99?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
Help with an if then scenario 2
Round Function 5
Round Question 3
Divide a # into 3 #'s rounded to a whole # 9
Formula help 2
Alternate Rounding Up & Down of .50 in a column 5
CAN I ROUND TO THE NEAREST # ENDING IN 99 FOR EXAMPLE 8

Top