Quickest Calculation formula for cell with 15 different possibilities

[Dman333]

Hi all,

I'm working on a new model that will be large and heavy. I'm trying to keep the recalculation time down and CAN'T USE VBA.

I have an input section with a dropdown list with 15 different ways to calculate the desired cost budget - per unit, % revenue, etc.. and there are 8 different products in columns that require the cell calculation.

I can use a real long If statement, but I'm wondering if there are any other ways to approach this that are faster when calculating.

Any suggestions are appreciated.

Thanks,
Dman333

Dorpdown Example.xlsx
	B
24
Sheet1

 

[SanjayGMusafir]

Please elaborate and be specific about your requirement. As of now, nothing is clear from OP.

 

[Dman333]

Hi Sanjay,

Thank you very much for taking the time to look at this. I was able to find the solution I was looking for so I'm closing this post.

Cheers!

 

[smozgur]

I was able to find the solution I was looking for so I'm closing this post.

Good to hear you got the solution.
Please note that questions are not closed in the MrExcel Message Board. If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.