Hi Stephen
If you make a formula numeric field, the formula editor will help you with the placement of parenthesis. If you write it out your conditions first like 'this AND this AND This OR This' it helps you make sense of all the fields involved:
If(
([Customer - Program]="Residential") and
([Measure]="M&V") and
([M&V_allclean]= "false")
and
([TO_CalculatedCFMPerTon]<340) or ([TO_CalculatedCFMPerTon]>460)
and
([Equipment - MeteringDevice]="TXV") and
([TO_Subcooling] > ([TO_SubcoolingTarget] + 5) or
([TO_Subcooling] < ([TO_SubcoolingTarget] - 5)))
or
([Equipment - MeteringDevice]<>"TXV" ) and
([TO_Superheat] > ([TO_TargetSuperHeat] + 5) or
([TO_Superheat] < ([TO_TargetSuperHeat] - 5))), 140)