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?
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?
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?
>
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?
> >
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?
> >
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.
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.
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks