asked on

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

zvitam

you implement the calculator within google sheets by using formulas & functions.

ASKER CERTIFIED SOLUTION

mohan singh

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Steve Harris

ASKER

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

Steve Harris

ASKER

Thanks again,
I've created a new question for this at:

Google sheets to enter Amount in a Special web calculator

Steve Harris

ASKER

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