Need an Expert at Google Sheets Formulas -- 3

I need an EXPERT at this. Please don't apply if you are anything short of an expert. If you accept the job and then can't complete it, I will issue negative feedback. You must speak fluent English as well. No ridiculous bids. I'm familiar with what this should cost.

I need you to make the following changes to a Google Sheet (will provide link upon job acceptance) but I've included a download of the file here.

All cells references are in the Calc sheet unless otherwise noted.

When computing cell D29, it pulls from the chart located in the Cal SupportSheet1. I need this to be calculated by pulling the cum interest number in column U of Cal SupportSheet1 at the last point when the total payable is positive (in this instance, in row 48… which would be $2,200.38 (U48). Keep in mind that the cell where this happens will change based on the numbers I enter in the spreadsheet.

The same for the calculation in G29. It uses a different chart in the Cal SupportSheet1

For cell I25, the current formula is:


I need the calculation to minus $F$2 and $F$7 ONLY if there is an X in cell I23

Please find out why cell J27, J29 & J31 isn’t calculating

Please also speed up the calculations in the spreadsheet. Sometimes when I change a number is takes up to 60 seconds for everything to recalculate.

Please have I30 and J30 calculate like the rest of the columns.

Skills: Accounting, Excel, Statistics, Mathematics, Google Sheets

See more: google sheets formulas sum, google sheets formulas if, google sheets filter multiple columns, google sheets formulas, google sheets formulas subtraction, google sheets formulas multiply, how to use google sheets formulas, google sheets formulas tutorial, google sheets lookup two columns, google sheets vlookup multiple columns, zapier google sheets formulas, google sheets formulas percentage, google sheets formulas cheat sheet, google sheets rank multiple columns, google sheets text to columns fixed width, google sheets compare two columns for matches, google sheets formulas not working, google sheets compare two columns conditional formatting, google sheets - compare two columns for duplicates, google sheets - compare two columns conditional formatting

About the Employer:
( 10 reviews ) Grandville, United States

Project ID: #29026076

11 freelancers are bidding on average $12/hour for this job


Hi, Greetings! ✅ I have checked and gone through the project details and I am very skilled in it. ✅Completed Time: In project deadline We have worked on 640 + Projects. I have 6 + years of the experience in sa More

$15 USD / hour
(403 Reviews)

Hi Mr. Employer, Basically the Google sheet is running by Javascript. So we have some knowledge in JavaScript. I have a lot of experience in Google sheets and I can do this project in an effective manner with 100% accu More

$14 USD / hour
(76 Reviews)

Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within 1 day

$15 USD / hour
(79 Reviews)

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be More

$12 USD / hour
(19 Reviews)

Hi, I have come across your post and as am expert in Google sheets would like to offer my services. A bit about myself, my academic qualification is Chartered accountant. For the past seven years I have gained conside More

$8 USD / hour
(35 Reviews)

Expert of Google sheet Already do many similar project and completed it within your budget, time My Qualifications as under-: #Chartered Accountant(ACCA/CPA) #Laywer/advocate #Masters in commerce #Certified Auditor # More

$8 USD / hour
(22 Reviews)

Greetings, I think here you are looking for an Expert at Google Sheets Formula. I have seen the attached file and understood your project description. I am an expert in Accounting, Excel, Statistics, Mathematics, G More

$12 USD / hour
(6 Reviews)

Hi I tried to download the attached excel sheet but it couldn't as I got an error i.e. HTTP ERROR 401. Could you please share that excel file or Google sheet link with me. I have read your instructions which you want More

$15 USD / hour
(2 Reviews)

Hey There, I have read through your project details clearly and understood things that need to be done. I will confirm with you once again when the project is awarded. But let me tell you a bit about myself so that yo More

$8 USD / hour
(0 Reviews)

Hello, I am Sam from Canada. I work as Business Intelligence Analyst in telecom industry. I am an expert in advanced excel. I looked into your file and took me 15mins to analyze the issues. Here are the key highlights More

$15 USD / hour
(0 Reviews)

Dear Sir, This is Mohd Noor Azmal Bin Md Zin from Malaysia, I'm an intermediate analyst. I have 4 Years’ exposure in Ms Excel analysing environment. I have relevant skills that you require. I have confident that I wi More

$12 USD / hour
(0 Reviews)