Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
General Real Estate Investing
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated almost 4 years ago on . Most recent reply

User Stats

62
Posts
49
Votes
Aaron Lietz
  • Lender
  • Mesa, AZ
49
Votes |
62
Posts

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

Aaron Lietz
  • Lender
  • Mesa, AZ
Posted

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?

Loading replies...