Google sheets to use a web calculator.

How can I use google sheets to use a web calculator.
Enter Amount, Term, & Interest Rate & return the 2 resulting values given by the calculator into the google sheet
Steve HarrisAsked:
Who is Participating?
 
mohan singhWeb developerCommented:
yes Mr ZVITAM is correct use formulas and create function

 create function like this
<?php

function interest($invest,$year,$rate=15,$n=1){
    $accumulated=0;
    if ($year > 1){
            $accumulated=interest($invest,$year-1,$rate,$n);
            }
    $accumulated += $invest;
    $accumulated = $accumulated * pow(1 + $rate/(100 * $n),$n);
    return $accumulated;
    }

?>
0
 
zvitamConsultantCommented:
you implement the calculator within google sheets by using formulas & functions.
0
 
Steve HarrisAuthor Commented:
Thank you for your reply. I did try to do this in Sheets;but, in this situation I'd need to use "GoalSeek" which is not available.

Sub Calculate()

   Sheets("Amort").Range("N22").Offset(rowOffset:=Sheets("Amort").Range("J5").Value, columnOffset:=0).GoalSeek Goal:=0, ChangingCell:=Sheets("Amort").Range("P10")
   Sheets("Amort").Range("W22").Offset(rowOffset:=Sheets("Amort").Range("J5").Value, columnOffset:=0).GoalSeek Goal:=0, ChangingCell:=Sheets("Amort").Range("P12")
   Sheets("Amort").Range("AY22").Offset(rowOffset:=Sheets("Amort").Range("J5").Value, columnOffset:=0).GoalSeek Goal:=0, ChangingCell:=Sheets("Amort").Range("P14")
       
End Sub

W22, N22, AY22 are the Loan amount 25,000.
J5 is 240 (20 Years)

My other alternative is to scrape the data from web, see picture attached
8F447AA5-3FF3-4664-B8B9-FDF0ED0AD93F.png
0
 
Steve HarrisAuthor Commented:
Thanks again,
I've created a new question for this at:

Google sheets to enter Amount in a Special web calculator
0
 
Steve HarrisAuthor Commented:
I am closing this as I have Asked a new Question at:
Google sheets to enter Amount in a Special web calculator
Posted on 2018-04-25

Which better defines what I am looking for.
I thank those that gave me new insight into php
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.