How to calculate GST price so that the final selling price will be a whole number?

It should be x*6%+x = 50. right?

Then again the GST has to be recalculated on 50. are you getting what i am saying?

Originally Posted by MarvinP

Hi,

I think you need a little factoring and a Round Function.

I believe a formula like
=Round(Price * (1 + GST), 0 )
Will give you what you want.

If the price is 47 and the GST is 6% then you should charge 47 * (1 + .06) rounded to the zero digit.
This will equal to 50.

Some sensible people will never open workbooks from strangers on the internet, so better to explain what you want in the body of your post.

If you mean you want the price including GST, ATP for after tax price, to be a whole number, the tax rate is t, the price before GST is BTP (for before tax price), then the math would be

ATP = BTP * (1 + t)

so a little algebra gives

BTP = ATP / (1 + t)

If you want ATP to be 47.00 and t were 6.00%, then

BTP = 47.00 / 1.06 = 44.34

Note: 44.34 * 1.06 = 47.0004 rather than 47.00. Some taxing authorities require ALWAYS rounding up no matter how small the fractional cents were, so in those jusrisdictions, BTP of 44.34 would result in ATP of 47.01, but BTP of 44.33 would result in ATP of 46.9898, so rounds up to 46.99. In other words, given specific tax regulations, some ATPs may be impossible to reach.

Thanks for the replay.
But just for your knowledge i am not stupid enough not to explain the question here in the post. And normally i can just reach to the answer of this type questions without much trouble, but unfortunately my mind just got frozen as i was trying too hard to reach the answer. So i just wanted to give my brain little rest so somewhat "i threw" the question here. Anyway by now i also have reached to a conclusion that we cannot get it 100% correct so this is no good unless legislation is amended.

Anyway thanks for all who helped and tried to help.

Regards.