User Profile
karelle167
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
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 with. I would like to combine all those files in one, but I need to apply different calculation parameters based on the type of program, and it's been difficult to do so without creating a high number of sheets. So, for now, I've created a dropdown list in the first sheet in which the user can choose the type of program he is working with. I would then like for the preset calculations in the other sheets to change according to the program selected. For example, if you choose program A in the dropdown list in sheet 1, the formula in cell B10 sheet 2 would be "=SUM(A1:H1)*2". But if you choose program B in the dropdown list in sheet 1, the formula in the same cell (B10) would be "=SUM(A1:H1)*5".This is one example, but I need to do so for a large number of calculation/parameters. In summary, how can I have different formulas change automatically in multiple cells on Sheet 2 based on a dropdown list in sheet 1? Thank you for your help, Karelle1.1KViews0likes3Comments
Recent Blog Articles
No content to show