I need to Round Cells up to next .99$

[Guest]

i have all kinds of different prices for items that i need to make all of
them no matter what the margin i give it it turns that cell to the next .99$
never rounding down only up even if its 15.01$ i need it to go to 15.99$
thanks for help

 

[Niek Otten]

=ROUNDUP(A1,0)-0.01

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|i have all kinds of different prices for items that i need to make all of
| them no matter what the margin i give it it turns that cell to the next .99$
| never rounding down only up even if its 15.01$ i need it to go to 15.99$
| thanks for help
|

 

[John Fuller]

You don't actually need to use VB to do this. You can simply use:
=CEILING(A1+0.01,1)-0.01
**I've assumed that you want $16-> 16.99 and 16.99 to stay at 16.99.

However, if you want to use VB, just do basically the same thing. Do
something like this:
Sub test_round()
For i = 1 To 4
initial = Cells(i, 1).Value
newValue = Application.WorksheetFunction.Ceiling(initial +
0.01, 1) - 0.01
Cells(i, 2).Value = newValue
Next
End Sub
Here I've assumed the initail values are in column A, and the resulting
values will be placed in column B. I've also assumed there are only 4
rows of numbers to be changed, but without knowing more about the data
structure, this is the best I can do.

 

[Mark K]

Assuming value to be rounded is in cell A1:

=ROUNDUP(A1,0)-0.01

 

[Guest]

With you data in A1: and downward

enter into B1 =INT(A1)+0.99
and Copy down