Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 16%
$32.50 /mo
$390 billed annualy
MONTHLY
$39 /mo
billed monthly
7 day free trial. Cancel anytime
Goals, Business Plans & Entities
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 about 9 years ago on . Most recent reply

User Stats

8
Posts
0
Votes
Michael Matthews
  • Rochester, NY
0
Votes |
8
Posts

Need help with excel formula

Michael Matthews
  • Rochester, NY
Posted
Hello everyone my name is Mike I'm new to bigger pockets and am starting to work some things up to help me do some numbers on properties. My problem is small I just need help with excel I have the number right but it's negative and I'm not sure how to fix the equation to make it positive. I know someone here is going to be a genius on excel. Also any tips and thought for improvement would be helpful. The equation I have is =d34*(d35+d36)-(d34)+d38+d40+d42 D34($14,400) d35 (10%) d36 (5%) d38 ($1,380) d40 ($1,440) d42 ($1,500) It's giving me -$7,920 which I just want to be $7,920 As I said it's more inconvenient than anything just for the spreadsheet I want it to be correct. Hopefully I can post a photo so you can see it though.

Loading replies...