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.