•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Solving for (constant/unknown=given value) where I give the desired output of a ratio and get the initial value needed.
- Excel Version Office 365 ver. 2603 build 19822.20182 click-to-run
- Excel Environment Windows desktop
- Your Knowledge Level Haven't touched excel in decades
- I have a formula where I input a value and it splits it in 3 ratios (0.1:50:50). D26 has the formula (=$A$1/100.1) to get the value of one part. B1-3 have the ratios 0.1, 50, and 50. C1-3 have the formulae (B1-3*$D$26) to get the shares of A1 by each ratio.
- I'm looking for a formula where I can input a desired share amount for any of the ratios and get the initial value needed to produce that share
EDIT: I know I'm probably waayyyyyyy overthinking this, but its driving me crazy
EDIT2: Example - An A1 value of 500 gives: a D26 of 4.995005, and C1-3 of 0.4995, 249.7502 and 249.7502.
I want to, for example, input a C1 of 500 and get the A1 required to get that. Which, plugging-and-chugging my example, would be 500500
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#natural language processing for spreadsheets
#generative AI for data analysis
#AI formula generation techniques
#formula generator
#rows.com
#enterprise-level spreadsheet solutions
#Excel
#formula
#Office 365
#ratios
#value
#Windows desktop
#desired share amount
#A1
#initial value
#D26
#shares