Forum Discussion
Excel formula help
Damien thank you so much for trying to help! I'm stuck! Maybe this just can't be done. I tried what you suggested, but it came back and said, "There are one or more circular references where a formula refers to its own cell either directly or indirectly. This might cause them to calculate incorrectly. Try removing or changing these references, or moving the formulas to different cells." :(
Hi jennigetz
Did you put the formula into L2? If you have put it into K2 it will become circular.
Cheers
Damien
yes I tried it in L2
I think the problem is that K2 is already a sum
It's not the biggest deal in the world, I just have to manually enter #s into L2 until K2 gets close to 4000
G & I use L so I think that's the problem
I'm just not that familiar with Excel, I'm proud of myself for even getting this far :)
Thank you again for trying to help!
Hi jennigetz
You are doing great and trial and error is part of the learning experience!
The example I gave was with K2 as a SUM and it worked OK (please see file attached).
What formula are you using in K2?
If you are able, it may be worthwhile to upload the file (remove any personal info) and I can have a quick squiz if you would like. Otherwise have a look at the file attached and see if that helps to pinpoint the issue.
Cheers
Damien
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...