Forum Discussion
Combining multiple non-numeric drop down menu values to produce a numeric pay rate value
I am trying to create an IF/Then formula using the results of multiple drop-down menus with non-numeric values to produce a currency value. I and my co-workers receive work through a union hiring ha...
I found a way to do it tediously by referring to each combo pair individually and attaching the desired result to the formula. I was hoping someone might know a way to do groups together. Like if I wanted to group 4 companies together who have the same pay rate for a task, then group 6 companies together of a different pay rate of the same task kind of thing.