# 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:

=I21-I19-I22-\$F\$2-\$F\$7

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.

Beceriler: Muhasebe, Excel, İstatistik, Matematik, Google Sheets

İşveren Hakkında:
( 10 değerlendirme ) Grandville, United States

Proje NO: #29026076

## Bu iş için 11 freelancer ortalamada \$12/saat teklif veriyor

schoudhary1553

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 Daha Fazla

\$15 USD / saat tutarından itibaren
(403 Değerlendirme)
8.2
royalcalif

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 Daha Fazla

\$14 USD / saat tutarından itibaren
(76 Değerlendirme)
5.7
writingapp

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

\$15 USD / saat tutarından itibaren
(79 Değerlendirme)
5.7
hayteekeys

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 Daha Fazla

\$12 USD / saat tutarından itibaren
(19 Değerlendirme)
4.8
dheerajjshetty19

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 Daha Fazla

\$8 USD / saat tutarından itibaren
(35 Değerlendirme)
4.9
oldaccountant

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 # Daha Fazla

\$8 USD / saat tutarından itibaren
(22 Değerlendirme)
3.9
chnsci

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 Daha Fazla

\$12 USD / saat tutarından itibaren
(6 Değerlendirme)
2.8
erparveenkumar

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 Daha Fazla

\$15 USD / saat tutarından itibaren
(2 Değerlendirme)
1.3
meniki2010

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 Daha Fazla

\$8 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
ranjansamit

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 Daha Fazla

\$15 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0
noorazmalmdzin

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 Daha Fazla

\$12 USD / saat tutarından itibaren
(0 Değerlendirme)
0.0