REVIT Panel Schedule IF Statement

[arhoadsNPJXT]

Hi all, 

I have been trying to figure out a way to automatically size the circuit breaker in my panel schedule based upon the loads in my panel schedule. I keep running into an error, "Inconsistent Units" to be exact. Below is the formula I am trying to use in my calculated value for my "Rating" parameter. 

if((True Load/Voltage*1.25) < 15, Rating = 15, Rating =20)

I am grabbing the parameters directly from the list so i know they are typed out correctly. I have also tried the trick where I multiply or divide by 1 to cancel out any additional units. 

Any help would be greatly appreciated. 

[CoreyDaun · Accepted solution]

I can't tell from the posted image, but is "if((True Load/Voltage*1.25) < 15, Rating = 15, Rating =20)" literally the written formula? If so, then the "Rating =" components are returning a 'true/false' value instead of a numerical value, which would result in the aforementioned error. If you omit that part, then the formula will return the value "15" in the condition is satisfied and "20" if it's not:

"if((True Load/Voltage*1.25) < 15, 15, 20)"

[arhoadsNPJXT]

Thank you! I can't believe it was something so stupid and simple! I didn't think about the True/False instance.