I'm attempting to create a (very long) formula for a circuit schedule, and I'm having issues getting the proper dictation for a simple formula before I start conjoining pieces to make the large one.
Essentially what I'm desiring to do is to insert a label within the schedule that shows the office standard of branch circuit labels. For example, a HNG #12cu branch circuit is labeled A20 within our office, a HHNG #12cu branch circuit is labeled B20, etc. I'm attempting to have the formula look at the calculated text within the Wire Size column (that I will later hide) and then based on the exact information shown for each circuit, spit out a label that I've told for each combination of wire sizes (yes, that will make for a very large formula).
Just to try and get one instance to work, I've tried the following formula:
if(Wire Size = "2-#1, 1-#1, 1-#6", "B125", "False")
(This is attempted under a Common discipline and Text type)
This formula kicks back the error "Improper use of boolean expressions."
Once I can master getting one wire size correctly dictated, I'll do something along these lines:
if(Wire Size = [text 1], [label 1], if(Wire Size = [text 2], [label 2], if(Wire Size = [text 3], [label 3], if(..... ))))))etc.
I'd appreciate any help with either this formula, or possibly even a better way to have a "smart" auto-completing column of custom labels for calculated wire sizes.