How do I get price calculations to always end in 9?

[Mr. Knobb]

I'm calculating retail prices at various gross profit percentages. I do this
by dividing the cost by the reciprocal of the desired GP%. I want the
results to always round up to the nearest 9, e.g. $3.29, 5.49, 2.99, etc.
How's this done?

[Vacation's Over]

Although common this can get a little complicated.
if you are sure that 2.00 = 2.09 then
for value in A1 put this formula where you want the answer
extra brackets for clarity....INT returns the integer

=(INT((10*A1)+1))/10)-.01

"Mr. Knobb" wrote:

> I'm calculating retail prices at various gross profit percentages. I do this
> by dividing the cost by the reciprocal of the desired GP%. I want the
> results to always round up to the nearest 9, e.g. $3.29, 5.49, 2.99, etc.
> How's this done?
>

[Mr. Knobb]

Thanks for replying/posting. That solution is close, but I need $4.37 to
round up to 4.39, not 4.99 as this formula does.

"Vacation's Over" wrote:

> Although common this can get a little complicated.
> if you are sure that 2.00 = 2.09 then
> for value in A1 put this formula where you want the answer
> extra brackets for clarity....INT returns the integer
>
> =(INT((10*A1)+1))/10)-.01
>
> "Mr. Knobb" wrote:
>
> > I'm calculating retail prices at various gross profit percentages. I do this
> > by dividing the cost by the reciprocal of the desired GP%. I want the
> > results to always round up to the nearest 9, e.g. $3.29, 5.49, 2.99, etc.
> > How's this done?
> >

[Mr. Knobb]

I think I got it!
Thanks!

"Vacation's Over" wrote:

> Although common this can get a little complicated.
> if you are sure that 2.00 = 2.09 then
> for value in A1 put this formula where you want the answer
> extra brackets for clarity....INT returns the integer
>
> =(INT((10*A1)+1))/10)-.01
>
> "Mr. Knobb" wrote:
>
> > I'm calculating retail prices at various gross profit percentages. I do this
> > by dividing the cost by the reciprocal of the desired GP%. I want the
> > results to always round up to the nearest 9, e.g. $3.29, 5.49, 2.99, etc.
> > How's this done?
> >

[[email protected]]

Mr. Knobb wrote:
> I'm calculating retail prices at various gross profit
> percentages. [...] I want the results to always round
> up to the nearest 9, e.g. $3.29, 5.49, 2.99, etc.
> How's this done?

And later:
> I think I got it! Thanks!

I'm glad you found your solution. Now, could you please
explain why you -- and other retailers -- like prices
that end in 9, especially 9 cents as you asked for.

I'm just curious. It seems to be a pervasive trait.

[Mr. Knobb]

I don't know the science, but there must be some. The practice is commonly
referred to as 'psychological pricing'. We're a very small hotel gift shop
retailer . That style of pricing is so common, I think it's expected. And
our prices are high, so it might help ease the pain a little...

"[email protected]" wrote:

> Mr. Knobb wrote:
> > I'm calculating retail prices at various gross profit
> > percentages. [...] I want the results to always round
> > up to the nearest 9, e.g. $3.29, 5.49, 2.99, etc.
> > How's this done?
>
> And later:
> > I think I got it! Thanks!
>
> I'm glad you found your solution. Now, could you please
> explain why you -- and other retailers -- like prices
> that end in 9, especially 9 cents as you asked for.
>
> I'm just curious. It seems to be a pervasive trait.
>
>