10bii Calculator Function in Google Sheets - Is it possible?

[Aaron Lietz]

If you are familiar with the 10bii app for payment calculations you might be able to help. I'm wondering if anyone can help me. Is there a way to create this type of functionality in Google Sheets? Basically I'm looking for a program or function that can solve for the missing variable(s), as long as there are 3 variables. In 10bii, there are 5 values (see below) and it allows you to calculate payments, interest rates, loan periods etc. I would like to duplicate this in Google Sheets (if possible). Any Sheets/Excel Ninjas out there in the inter-webs who can help?