ryanjgillies
New Member
- Joined
- Mar 2, 2016
- Messages
- 1
Hi all
My Data Tables seem to be ignoring the second variable, and only calculating column inputs.
I'm trying to do a What If analysis to see how projected income will vary dependant on revenue growth percentage and EBIT margins. The Data Tables are all calculating the growth percentage (variable one) but not taking into account the second variable. I've disabled auto-calculate on Data Tables for convenience sake, but that is not the issue, calculating the entire document changes nothing.
You can view my spreadsheet on OneDrive.
Can anyone advise?
My Data Tables seem to be ignoring the second variable, and only calculating column inputs.
I'm trying to do a What If analysis to see how projected income will vary dependant on revenue growth percentage and EBIT margins. The Data Tables are all calculating the growth percentage (variable one) but not taking into account the second variable. I've disabled auto-calculate on Data Tables for convenience sake, but that is not the issue, calculating the entire document changes nothing.
You can view my spreadsheet on OneDrive.
Can anyone advise?