Forum Discussion
Solved
Need help with fixing some formulas...
I have a 10-year income/expense budget projection for a condo-hotel operation. There is a 60-40 split of rental revenue after expenses between the hotel owner and the individual owners of each condo...
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%.
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!😃👍🏼