•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Mirrored Values in Data Table
I'm trying to do a sensitivity table which changes the value of the share price based on changes in the WACC and growth rate but have been getting duplicate/mirrored? values.
Not sure if formula text is enough for anyone to get the picture, but feel free to ask for more details. Also the 10.06% on the left side of the data table is linked to the WACC input in blue, and the 2.00% at the top of the table is linked to the growth rate in blue.
And of course the cell on the top left is linked to my equity value/share.
Thanks in advance!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#rows.com
#real-time data collaboration
#intelligent data visualization
#AI formula generation techniques
#Excel compatibility
#cloud-based spreadsheet applications
#sensitivity table
#WACC
#data table
#share price
#growth rate
#equity value
#duplicate values
#mirrored values
#linked cells