Round to .99?

G

Guest

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

Round Function 5
CAN I ROUND TO THE NEAREST # ENDING IN 99 FOR EXAMPLE 8
round to one of two numbers 5
Round Question 3
Alternate Rounding Up & Down of .50 in a column 5
Rounding numbers up or down in same formula 6
Formula help 1
Rounding to nearest 250 by 125s 3

Top