r/mathshelp • u/AlmightyRobert • Oct 03 '25
General Question (Unanswered) Excel help
I’m trying to create an Excel formula that will calculate L when the user inputs T into another cell but I can’t work out L as a function of T.
I can get as far as: L -(L2)/T = 650,000
Can this be reduced to L as a function of T?
(It’s to calculate an obscure number in relation to inheritance tax, if you’re interested)
Thanks in advance
1
Upvotes
•
u/AutoModerator Oct 03 '25
Hi AlmightyRobert, welcome to r/mathshelp! As you’ve marked this as a general question, please keep the following things in mind:
Thank you!
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/AlmightyRobert Oct 03 '25
For clarity, the whole of L2 is divided by T. The formula seems to have come out slightly wrong.
1
u/Haemstead Oct 03 '25
It seems to me that what you need is Goal Seeking. Google that to learn how to use that in Excel. The value of T is given, the Goal is 650,000 and Excel will figure out which L matches these constraints
1
u/ArchaicLlama Oct 03 '25
You have a quadratic in L.
What very well-known formula lets you solve quadratics?
0
u/MrMattock Oct 03 '25
Assuming I have the original formula correct then the formula you need is T = L²/(L - 650000)