Need an Expert at Google Sheets Formulas -- 3
$8-15 USD / oră
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.
ID Proiect: #29026076
Detalii despre proiect
11 freelanceri plasează o ofertă medie de 12$/oră pentru proiect
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 Mai multe
Hi. I have written many automation GoogleSheet scripts. Ready to write your project. Will complete within 1 day
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe
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 Mai multe