I have a list of rows where each line is multiplied the same way. =A*B*C where the value in column "C" is actually one of three values/columns based on the scenario i.e. "C1" "C2" "C3".
I would like to be able to have a drop down cell somewhere in the spreadsheet that allows me to choose the scenario "C" (C1, C2 or C3) so that it multiplies against column A and B (these are always constant) based on the variable "C". What would be the best function to use?
I would like to be able to have a drop down cell somewhere in the spreadsheet that allows me to choose the scenario "C" (C1, C2 or C3) so that it multiplies against column A and B (these are always constant) based on the variable "C". What would be the best function to use?