Try this:

A1: 4.50
B1: =A1*2.9

C1: =INT(B1)+0.99

Or maybe?....
C1: =CEILING(B1,1)-0.01

Helping yet?
***********
Regards,
Ron

XL2002, WinXP


"Smatass" wrote:

Hey Ron, thanks for the reply. I tried that, but it didn't work as expected.
Let me be more specific as to exactly what I am doing so we are on the same
page. This is what I am working with:

- column 1 = my price for product, say 4.50
- column 2 = retail price, which I have a simple formula (a1*2.9) which
works, for both the spreadsheet and my wallet :P
- so the total in column 3 equals 13.05, but I want it to equal 13.99

When I put in your formula, it gives me the wrong price for column 2 since
it negates the other formula, and I know you can't reference the same cell
that you are putting the formula in.. so i've been sitting here trying to
figure out how that could even possibly work without referencing the same
cell as the formula. I have no idea. You?


So if

"Ron Coderre" wrote:

See if this points you in the right direction:

With
A1: (a numeric value)

B1: =INT(A1)+0.99

Is that something you can work with?
***********
Regards,
Ron

XL2002, WinXP


"Smatass" wrote:

I am finishing up a product list for a new retail store. We have 4328
separate products, and each one I have had to enter manually by hand. Now I
need to make every item end at 99 cents (.99) for the price column, but I
cannot figure out how to do this with the roundup functions, or any function
for that matter. I really don't want to manually go thru 4000 items again
just to change the *&!*@&*!&@#! price. So if anyone has some knowledge on
this, drop it. I'll love you forever.