General Real Estate Investing
Market News & Data
General Info
Real Estate Strategies
Short-Term & Vacation Rental Discussions
presented by
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/hospitable-deef083b895516ce26951b0ca48cf8f170861d742d4a4cb6cf5d19396b5eaac6.png)
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Tax, SDIRAs & Cost Segregation
presented by
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_trust-2bcce80d03411a9e99a3cbcf4201c034562e18a3fc6eecd3fd22ecd5350c3aa5.avif)
1031 Exchanges
presented by
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_1031_exchange-96bbcda3f8ad2d724c0ac759709c7e295979badd52e428240d6eaad5c8eff385.avif)
Real Estate Classifieds
Reviews & Feedback
Updated almost 4 years ago on . Most recent reply
![Aaron Lietz's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/1383121/1690477744-avatar-aarondlietz.jpg?twic=v1/output=image/crop=1200x1200@0x0/cover=128x128&v=2)
10bii Calculator Function in Google Sheets - Is it possible?
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?
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1619152880-image.png)
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1619152665-image.png)