Do some Excel Work

已完成 已发布的 Nov 14, 2015 货到付款
已完成 货到付款

Hi everybody,

I need someone to create a formula in excel which can do calculation like below:

Total: INR20517.4

VAT(14%): [url removed, login to view]

Total: [url removed, login to view]

Shipping: INR130

Total: [url removed, login to view]

charges: [url removed, login to view] & [url removed, login to view]

: [url removed, login to view] & [url removed, login to view]

: [url removed, login to view] & [url removed, login to view]

: [url removed, login to view] & [url removed, login to view]

: [url removed, login to view] & [url removed, login to view]

Explanation: The total is [url removed, login to view] so I will calculate 2.65% for [url removed, login to view] and the result will be [url removed, login to view] and then I will calculate 14% of [url removed, login to view] and the result will be INR87.25. Then it should automatically add [url removed, login to view] and [url removed, login to view] to the Total of [url removed, login to view] which will make the total of INR21227.92.

Then again, we will calculate same as above steps:

Total: [url removed, login to view]

VAT (14%): [url removed, login to view]

Total: 24199.82

Shipping: INR130

Total: [url removed, login to view]

Explanation: The total is [url removed, login to view] so I will again calculate 2.65% for [url removed, login to view] and the result will be [url removed, login to view] and then I will calculate 14% of [url removed, login to view] and the result will be INR90.26. Then it should automatically add [url removed, login to view] and [url removed, login to view] to the [url removed, login to view] which will make the total of INR21252.40.

So it should continuously doing these calculation until or unless the last two iteration which you can see in the "charges:" becomes same and I only need the output of last iteration. Last iteration is what I need in result.

So let's start........

I need the code for this formula so that I can apply in many excel files I want.

Payment terms: I will pay only after the completion of work and handed over the formula/code to me.

数据输入 数据处理 Excel Visual Basic

项目ID: #8905212

关于项目

33个方案 远程项目 活跃的Nov 15, 2015

授予:

gokulanand

Hello I went through your description and I understand your requirement. I can get it done in the next 2 to 4 hours. Let me know if you are interested. Thanks

$15 USD 在0天内
(73条评论)
5.6

有33名威客正在参与此工作的竞标,均价$21/小时

prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do make formula like u need Sir :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prames 更多

$15USD 在1天里
(172条评论)
6.0
cgullapalli

Hi, I am good at excel. Looking forward to work on this project. I have seen the description. I can make it in excel file.

$20 USD 在0天内
(101条评论)
5.4
macroPOL

Hello, I can do this project in few minutes. payment after handed over the formula - it is ok,

$15 USD 在0天内
(17条评论)
4.5
TonmoyRoy111

A proposal has not yet been provided

$25USD 在1天里
(44条评论)
4.3
naseefo

A proposal has not yet been provided

$60USD 在1天里
(6条评论)
3.5
remisanonymous

Hi, I can do macro for these calculations in Excel VBA, of course, if you choose me as the winner. Best regards, Remis

$15USD 在1天里
(9条评论)
3.1
arpankumarde

A proposal has not yet been provided

$15USD 在1天里
(4条评论)
1.6
Skatez

Hi , I can start working on this project right now. I have been working previously in excel and have some experience with it. Give me a chance to prove it.

$20USD 在1天里
(0条评论)
0.0
vmuthu91

A proposal has not yet been provided

$25 USD 在5天内
(0条评论)
0.0
Pradeepsharmarch

looking forward to work with you.

$25 USD 在2天内
(0条评论)
0.0
nkodumuru

A proposal has not yet been provided

$15 USD 在2天内
(0条评论)
0.0
ArvinderSand

I am very much perfectionist and reliable towards my work and always given the best to my clients. If you are looking to hire someone for the following talents, I can assure that I will best suit your work. • Data E 更多

$25USD 在1天里
(0条评论)
0.0
USHKING

Hi , How many iteration are needed, Attaching a sample let me know if chosen it is what is requested? VAT C2 INR TOTAL INR VAT + TOTAL INR SHIPPING VAT TOTAL INR 23519.83 623.28 87.26 20517.40 21227.93 24199.84483 更多

$30USD 在1天里
(0条评论)
0.0
roastbeeef

I could probably do this in 5 minutes for you... let me know. I've been an excel analyst for the last 6 years.

$20USD 在1天里
(0条评论)
0.0
aakashswami7

During my engineering i work on various project and we use to make calculator for big formulas in excel which makes our work easy. so its easy, can do it.

$15USD 在1天里
(0条评论)
0.0
Bogurodzica

Hi! I am native polish speaker, therefore i use this language a lot in my common life. I study philology and IT at the University of Warsaw, meanwhile work as translator and give private lessons. That sort of work 更多

$35 USD 在5天内
(0条评论)
0.0
yousafshahzad

A proposal has not yet been provided

$25USD 在1天里
(0条评论)
0.0
guptadhruv

Greeting of the day! I would be glad to work on this project for you and start right away. Being a new freelancer, money does not matter,however I can assure you 100% quality absolutely error free. "I can clearly 更多

$10USD 在1天里
(0条评论)
0.0
benamoon

A proposal has not yet been provided

$10 USD 在0天内
(0条评论)
0.0
archanaoswal

I have a good hold on Excel and I can complete it within a day

$15USD 在1天里
(0条评论)
0.0