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!
Now that Riny_van_Eekelen has answered your question, may I strongly suggest that you edit your post with the link to your spreadsheet and remove that link. Your spreadsheet contains no individual information per se, but clearly has a lot of what I would assume to be business-confidential data.
- Done. Thank you very much for your help!