Forum Discussion
Formula variations linked to a dropdown list
Hi everyone, I'm new to this community. I'm working on a budget analysis model for new academic programs. I am currently using multiple excel files depending on the type of program I am working ...
If you don't want to do this using VBA, I would suggest using something along the lines of =Choose( n, "=SUM(A1:H1)*2", "=SUM(A1:H1)*5", …) etc. to switch between formulas. You should be able to search for how to do this on line.