I have a spreadsheet calculating expected returns on certain investments. There is a different equation to calculate the return for each different type of equation. i want to build an equation like
"=if(a1="IRA",'IRA schedule equation'!A1,if(A1="Roth IRA",'Roth IRA Schedule'!A1),"Error"))
Where A1 in the respective sheet would hold the calculating equation. I tried this, and it doesn't behave as though the equation is in the current sheet cell. Is there a different way I can implement this?
Bookmarks