Assign a value to a label in a label column, the multiply by a number field

[Wayne]

Hi Team

Its safe to say formulas are a little over my head. I’m looking to see if there is a possibility of assigning a value to a label field, then multiply that value by another number.

For example I would like to assign “Q.Cell” to a value of 0.3, then multiply by 20 to give me 6 in “System Size” (Formula column).

Note, there about a total of 7 labels

[JCorrell (Jim - The Monday Man)]

@Wayne

Try this:

SWITCH({Panels}, "Q.Cell 330", 0.3, "Trina 400", 0.4, ...., 999999) * {Number of Panels} 

---

Jim - The Monday Man
Column Magic - the magical columns toolbox app