Excel SpreadSheet IF,Then formulas

DELIVERABLE: is to derive the difference between 1% NCDF [Column L] in Sheet "Payment2017" and " Amount in [login to view URL]" [Column E] in Sheet Remittance2017, using Vendor Name and Document Number of both sheets as the matching factors.

In my crude attempt, I have created a "NAOC Remit" Column M in Sheet "Payment2017" and I have been manually picking from "Remittance2017" to derive the Difference [Column N].

Please do not apply if you do not understand what I need you to do.

Here's a sample of the job.

Taidot: tietojenkäsittely, Excel, Excel Macros, Excel VBA, Visual Basic

Näytä lisää: excel if statement text, multiple if statements in excel with text, how do you write an if then formula in excel?, if then statements excel, if formula excel multiple conditions, excel two conditions in if statement, what is the if then = statement?, excel if statement multiple conditions range, excel spreadsheet quickbooks, send bulk mail excel spreadsheet, reformat excel spreadsheet, year plan excel spreadsheet, excel spreadsheet surgery cost, convert excel spreadsheet label, convert excel spreadsheet standalone application, multi level marketing pay plans excel spreadsheet, parse word document excel spreadsheet, excel spreadsheet vba data entry form, locking formulas excel spreadsheet, excel spreadsheet formulas

Tietoa työnantajasta:
( 1 arvostelu ) Ikoyi, Nigeria

Projektin tunnus: #19849922

Myönnetty käyttäjälle:


Hello. Welcome! I'm excited that you’re here! ✅ I have fully read the task, and assure that I can complete the task with no error. ☻My idea :" It proves that the best food is honest food, made to uncomplicated recip Lisää

$30 USD 7 päivässä
(5 Arvostelua)

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$30 USD 1 päivässä
(322 Arvostelua)

31 freelanceria on tarjonnut keskimäärin 21$ tähän työhön


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Lisää

$30 USD 1 päivässä
(334 arvostelua)

Hello, this is definitely possible, but i need to ask few follow up question about connecting the two sheets. If you are interested in working with me, please message me so i can ask you few follow up questions. I am a Lisää

$20 USD 0 päivässä
(492 arvostelua)

Dear Sir/Madam, I'm happy to help you on this task. I.m an expert in advanced excel skills and can do this task within few minutes. You can refer my profile to see details about me and my reliability, and if you are Lisää

$25 USD 0 päivässä
(191 arvostelua)

Hey there! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer, currently at the post of Forum Expert at I checked the attached sheet and can provide you both macro or form Lisää

$15 USD 1 päivässä
(102 arvostelua)

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Lisää

$30 USD 1 päivässä
(107 arvostelua)

Hello there, I am an Excel expert and I have thounsand ways to complete this task for your. Formula or VBA/Macros is no problem with me. Please contact and you can get your result in 15 mins. Thanks

$20 USD 1 päivässä
(88 arvostelua)

hello! let me help you. I offer high quality and accurate output. Just award the project to me and I will take care of the rest. Hope you will consider me, thanks.

$20 USD 7 päivässä
(26 arvostelua)

Hi, since you have to criteria for finding the matched column in the second worksheet, so we have to use Macro to finding the related amount (Base on vendor name and document number). Also, if you think you can work wi Lisää

$30 USD 1 päivässä
(8 arvostelua)

Hi, I have gone through the attached excel and able to get your requirement. I can write a macro to get the difference between 2 columns only when doc number of both sheets are matching and print the value in N colu Lisää

$20 USD 0 päivässä
(4 arvostelua)

Hi Good Day! A serious freelancer here. I know how to do it. Please message me for the file. I've done a lot of Reports and Templates using MS Excel. Please consider my bid. With my experience as a VBA Macro Lisää

$15 USD 0 päivässä
(26 arvostelua)

Hello Diseph, I've already done a test on your file and I can send you the sample over chat to confirm that this is what you are looking for. BR, Razvan

$20 USD 2 päivässä
(6 arvostelua)

Quite easy to use a formula to match the Vendor Name and Document Number of the two sheets and perform the calculation. I can actually do it in 1 day, but I have some other appointments, so it will take a few more days Lisää

$12 USD 7 päivässä
(1 arvostelu)

I have FULL CONFIDENCE of completing this Excel formula to calculate the differences column in Payment2017 worksheet. (The manual method column M in Payment2017 is NOT needed. ) This is an example of megaformula (but Lisää

$15 USD 1 päivässä
(2 arvostelua)

please chat with me to upload you the file after updated from me, to see together if Ok or not (I solved with another way). CV: I am software engineer, Holder of a degree in Faculty of Information Technology - Univers Lisää

$30 USD 2 päivässä
(1 arvostelu)

I have a lot of experience in excel and advanced excel. The problem at hand can be solved using vlookup. Please assign this project to me and I shall share the solution in about an hour. Relevant Skills and Experience Lisää

$20 USD 1 päivässä
(1 arvostelu)

I have vast experience working with advanced excel for more than 8 years. I also hold a degree in Information Systems. I already worked on your sample and can replicate the results on your full data ASAP.

$20 USD 1 päivässä
(0 arvostelua)

I worked in a big bank , I used Excel (macros) to solve many different problems, so I could help you with your Excel file. Since I'm new in this platform I'm not requiring a high pay. greetings

$15 USD 1 päivässä
(0 arvostelua)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned "I can do th Lisää

$27 USD 7 päivässä
(0 arvostelua)

hello, I clearly understand the requirement. I can do this with Excel formula. it doesn't need much effort. hope for the response. Thanks!

$15 USD 1 päivässä
(0 arvostelua)

Hey, I can do your work and can do for a long time because I need to work for my studies. I can do every work with great responsibility. I can do it better than others. It belongs to my group of studies. I will be your Lisää

$18 USD 7 päivässä
(0 arvostelua)