Forum Discussion
Excel formula help
wow I really appreciate your time
I've attached my spreadsheet
I am a real estate broker and I am trying to help my buyers understand what they can afford in each neighborhood
Each has different HOA fees and taxes
This particular client wants to stay under $4,000/month
I think I've done everything right, I'd just like to not have to manually enter the purchase price amount in L
I'd like for L to be able to calculate itself based on everything else and keep K under $4,000
I hope this makes sense
If you have a minute to take a look I'd be very appreciative...
Hi jennigetz
Ok I think I'm following your line of logic now.
The one thing I'm missing in my head is how you calculate $545,000 as the purchase price?
How do the numbers you have there equal to that? E.g. for K2 is this amount over a term of 12 years to arrive at the purchase limit?
Cheers
Damien
Hi jennigetz
I've explored your spreadsheet a bit more and you should definitely stick with the current model and just trial and error the prices.
The problem other than the circular reference is that you also have other variables that are manually entered such as HOA, Special Assessment tax. Very hard to program a formula without knowing how these values are calculated.
Best wishes with your work and have a great week ahead!
Cheers
Damien
I just made it up :)
I just started plugging in numbers in the L column until it hits $4,000 or less in the K column
That's the problem, that's what I want to avoid doing
It's time consuming to fill in all the other #s and then have to trial and error #s in L
But if I have to, I have to, it's not that big of a deal, I was just hoping there was something I was missing and a formula could be plugged in to do it for me
Thank you again!