Fermé

rounding total values including and excluding tax

rounding total values including and excluding tax, Need advise on what approach to follow.

We have 2 items:

Total payable value:

Item 1 costs: 4.29

Item 2 costs: 12

Tax:

For item 1 is: 5%

For item 2 is: 12.5%

Ex Vat (calculated from Total value):

Item 1: 4.0857

Item 2: 10.6667

Now the calculations will go:

Item 1: 4.0857 * 5% = 0.204285 (rounded to 2 digits decimal - 0.20)

Item 2: 10.6667 * 12.5% = 1.3333375 (rounded to 2 digits decimal - 1.33)

Total for basket = 16.29 (as ex vat value is calculated from total value)

Total from [login to view URL] + taxes: 4.0857 + 0.204285 + 10.6667 + 1.3333375 = 4.289985 + 12.0000375 = 16.2900225 (rounded to 2 digits: 16.29)

If I loose the precision on calcs (for example I calculate tax value from 2 digit decimal number, ex 4.09 * 5%), it will create chain reaction which will enlarge total value to 16.30 (after rounding), so it will create another set anomalies that will affect total value as well.

Anyone has a good idea?

Compétences : Comptabilité, Finance, Data Analysis, e-Commerce, Paniers d'Achat

Concernant le client :
( 1 commentaire ) Farnborough, United Kingdom

Nº du projet : #33731989

15 freelances font une offre moyenne de 24 £ pour ce travail

daniyal3214

Hello, I will be glad to assist you with that. I am an experienced Financial Analyst and Excel expert holding years of experience in Financial Analysis, Financial Modeling and Corporate Finance. Lets discuss your proje Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(217 Commentaires)
7.0
(133 Commentaires)
6.3
AccountantArman

"Sir, Shall we discuss it on chat.? I am Excel and Tax Advance Level Expert. This is a basic work for me. i can complete this project with added quality. About me I am Chartered Accountant with more than 6 years of e Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(107 Commentaires)
6.2
(14 Commentaires)
4.8
Nsarker1242

Hi client, I'm an Associate professor good knowledgeable about economics Analysis, Home economics, Applied economics. I am an expert in financial analysis using R program code. Feel free to contact me. Best regards, Th Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(1 Évaluation)
3.1
(4 Commentaires)
2.9
DWSol

Responsive Website Designing/Developmentrounding total values including and excluding tax Hi, rounding total values including and excluding tax, Need advise on what approach to follow This is Sairus Khalil from DW So Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(1 Évaluation)
2.6
alamineee

Hi, Dear Employer, I am a Ph.D. backgrounder professional in Finance and professionalization with Finance ✔R programming ✔SPSS Statistics ✔Statistical Analysis. I have worked on several similar projects in freelancer. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(3 Commentaires)
2.2
(4 Commentaires)
1.7
mramzantariq6

Hi there, I'm Chartered Accountancy student and I deal with such kind of calculations every day. I've expertise in tackling with such tricky figures as is my field. Do hit me up to discuss details. Looking forward to h Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(2 Commentaires)
1.2
remuslupinhp

Hi Friend, I can automate these tasks for you using power query and macros in excel. In future, you will only have to input data and you will get the result automatically. Please give me a chance to work on this task Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(1 Évaluation)
1.3
(0 Commentaires)
0.0
erikaschittone

Apply from the beginning, the recounting formula in the value of the cost. Item 1 Item 2 Costs 4,09 10,67 % - Tax 5,0% 12,5% Tax 0,20 1,33 Total Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 40 jours
(0 Commentaires)
0.0
brianho1228

It just easy to fix with some basic vat concept. When you know how vat work, this problem can solve in a minute.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% GBP en 1 jour
(0 Commentaires)
0.0
suhu1993

Prefect fit, as i love diddling with numbers in excel. Prior experience in doing similar functions.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(0 Commentaires)
0.0