Formula...don't know where to start
I have 3 columns. The cells in each column can have a value of Low, Medium, or High. In a fourth column I want to return a value based the combination of Low, Medium, or High selected in the other three cells. So:
Two or more highs = 4
One high and two mediums = 4
One high, one med, one low = 2
Three mediums = 2
Two mediums and one low = 1
One medium and two lows = 0.5
Three lows = 0.25
This formula far exceeds my abilities. Any takers?
Help Article Resources
Check out the Formula Handbook template!