Forum Discussion
Need help with fixing some formulas...
E47 contains:
=(E45-E51)*'Condo Unit ProformaAssumptions'!$E$14
E49 contains:
=(E45-E51)*'Condo Unit ProformaAssumptions'!$E$13
The file is in Viewing mode. When I change it to Edit mode external links are removed and can not see the Assumptions sheet. But I guess E14 in that sheet contains 60% and E13 contains 40%. Just change it to 40% and 60%.
Here is the link to the spreadsheet in my OneDrive:
[Link Removed]
I have highlighted in yellow the 2 cells in each column (10 columns total, 1 for each year) that need to have the formulas flipped with the other highlighted cell in each column (from a 40-60 split to a 60-40 split). Thanks for your help!
E47 contains:
=(E45-E51)*'Condo Unit ProformaAssumptions'!$E$14
E49 contains:
=(E45-E51)*'Condo Unit ProformaAssumptions'!$E$13
The file is in Viewing mode. When I change it to Edit mode external links are removed and can not see the Assumptions sheet. But I guess E14 in that sheet contains 60% and E13 contains 40%. Just change it to 40% and 60%.
- Thank you! It worked! I appreciate your help very much. Have a great day!😃👍🏼