Two formulas in one excel

See sheet. It's a travel budget.

B2 = total budget

Row 4 to 15 shows spend per city

With the current budget, we can travel untill Berlin, and have 1268,00 money left.

Request to you: Automate field B17 to show the name of the latest viststed city based on budget in B2

Then show in B18, the amount of money left. When field B2 changes, B17 and B18 should recalculate

Skills: Excel, Data Processing, Data Mining

See more: create formulas excel, formulas excel money, lock formulas excel, two formulas in one cell google sheets, multiple formulas in one cell excel 2013, excel two formulas in one cell if, multiple calculations in single formula, nesting formulas in excel, excel multiple functions in one cell, two results in one cell excel, how do i combine two formulas in excel, how do you combine two formulas in excel, how do you put multiple formulas in one cell in excel, morgage formulas excel, excel date format changes number, inputting formulas excel accounting, save excel file current date using vbs, excel date field changes number sign, locking formulas excel, locking formulas excel spreadsheet

About the Employer:
( 3 reviews ) KOOG AAN DE ZAAN, Netherlands

Project ID: #26544940

Awarded to:


Hi, this is very simple formula, and i can create it in matter of minutes. If interested in working with me, feel free to message me and i will create it immediately. Thanks, Milan

€8 EUR in 1 day
(550 Reviews)

51 freelancers are bidding on average €17 for this job


Hi, Greetings! ✅checked your project details: Two formulas in one excel ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you More

€20 EUR in 1 day
(371 Reviews)
(194 Reviews)

Hello Greetings to you!! ✅checked your project details: ✅Completed Time: In project deadline I am an Excel (Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and tha More

€25 EUR in 1 day
(314 Reviews)
(128 Reviews)
(157 Reviews)

I have seen the Excel sheet. It's a few minutes job. I am ready to provide the formuals in both the cells right now.

€10 EUR in 1 day
(163 Reviews)
(109 Reviews)
(22 Reviews)

Hi, JUST 30 MINS I have gone through the project description and understood what you need help with.......... Text me so that we can start the project immediately. Thanks.

€15 EUR in 1 day
(31 Reviews)

ok sure i can set formulas on your travel sheet as you want i have seen your attachment sheet pls PM me wait for reply thanks

€20 EUR in 7 days
(37 Reviews)

Hi, I have completed the task with a vlookup and an index-match function. So, now if you type 17000 as budget in B2. B17 will automatically show Antwerp. B18 will have left over budget as 768. Please let me know if you More

€20 EUR in 1 day
(6 Reviews)

Hello!! Am very interested in ur project and I'm an expert in PDF/Word/Excel/Excel Marcos/VBA/Visual basic/Copy typing/Data Entry/Data processing and would like to help you with your project. Please ping me for further More

€8 EUR in 1 day
(17 Reviews)

DONE message me so i send you the file exactly as requested. Cheers John

€8 EUR in 1 day
(3 Reviews)

DEAR SIR/MADAM, I ca definitely do the task as I am Chartered Accountant(ACCA) and expert EXCEL. You can see my profile I do have the relevant skills to do the assigned job within the time period mutually agreed upon More

€20 EUR in 7 days
(15 Reviews)

hi there. My name's Benne and I have helped thousands of people via Excel forums, training, and consultancy projects. i have looked at your file and done up the solution for you. here's a video: https://streamable.c More

€10 EUR in 1 day
(3 Reviews)

Hello, I have gone through with contents and attached files to understand the requirements. I am interested to do this work and break your huddle. Please allow me to do this job. I am available to support you 24*7 just More

€19 EUR in 7 days
(6 Reviews)

Hello! I hope yuo are doing well. I have understood your requirements properly as its clearly written on your project description that how you want the results. I can complete this task by the next 12 hours. I am avail More

€15 EUR in 1 day
(8 Reviews)

Hi, I am expert in data collecting,data scrapping, data mining and data hunting with great web search as well as having great research skills and tools. I am expert in data processing. I will be provide full satisfacto More

€8 EUR in 1 day
(6 Reviews)

Hi I have good experience in excel and Excel VBA. I can automate your requirement And can be done in a matter of minutes. Please initiate chat to discuss and send me the file.

€19 EUR in 1 day
(4 Reviews)

Hello! I am happy to put my bid on your project. I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel formula and VBA. Everyone call More

€20 EUR in 1 day
(3 Reviews)