I am trying to calculate a value which is using a different multiplier depending on the cell value (text) in a column (K):
The text value options are “peak”,”shoulder”,”off-peak” which are listed in column K
The rate options (multipliers): J2 for peak, J4 for shoulder, J6 for off-peak
I then want to set up a formula in column L to multiply the value in column D with the appropriate multiplier based on the text value in column K.
Thanks in advance