Forum Discussion

StephenAnguiano's avatar
StephenAnguiano
Qrew Cadet
8 years ago

Formula Syntax Error

I keep getting a syntax error for the current formula. Any ideas what I am missing?

If([Measure]="M&V" or [Measure]="Modeled" or [Measure]="Post measurement",  
If([PercentChange1]=0 and [PercentChange2]=0 and [PercentChange3]=0 and [PercentChange4]=0,
If([SavingsCalcVersion]= "2016" and [Customer - Utility]="ABC",    
If(Contains([Equipment - BuildingType],"amily"),0.117,0.083),    
If([BlowerCleaned]=true and [EvaporatorCleaned]=true,      
If([Customer - State]="TX" or [Customer - State]="NM",0.11,0.109),      
If([Customer - State]="TX" or [Customer - State]="NM",0.093,0.095))))),    
If([SavingsCalcVersion]= "2017" and [Customer - Utility]="ABC",    
If(Contains([Equipment - BuildingType],"amily"),0.136,    
If([Equipment - NominalTonnage]<25,0.1,0.081)),    
If([Customer - State]="TX" or [Customer - State]="NM",      
If(Contains([Equipment - BuildingType],"amily"),0.083,0.07),    
If([BlowerCleaned]=true and [EvaporatorCleaned]=true,0.101,0.087))),    
If([SavingsCalcVersion]="2018" and [Customer - Utility]="ABC",   
If(Contains([Equipment - BuildingType],"amily"),0.136,    
If([Equipment - NominalTonnage]<25,0.1,0.081)),    
If([Customer - State]="TX" or [Customer - State]="NM",      
If(Contains([Equipment - BuildingType],"amily"),0.0483,0.0848),    
If(Contains([Equipment - BuildingType], "amily"),0.0639,0.0866))),    
If([SavingsCalcVersion]= "2016" and [Customer - Utility]="ABC",    
If(Contains([Equipment - BuildingType],"amily"),0.192,0.15),        
If([BlowerCleaned]=true and [EvaporatorCleaned]=true,          
If([Customer - State]="TX" or [Customer - State]="NM",0.149,0.154),      
If([Customer - State]="TX" or [Customer - State]="NM",0.12,0.112))),    
If([SavingsCalcVersion]= "2017" and [Customer - Utility]="ABC",    
If(Contains([Equipment - BuildingType],"amily"),0.184,    
If([Equipment - NominalTonnage]<25,0.139,0.105)),    
If([Customer - State]="TX" or [Customer - State]="NM",      
If(Contains([Equipment - BuildingType],"amily"),0.148,0.147),      
If([BlowerCleaned]=true and [EvaporatorCleaned]=true,0.146,0.107))),    
If([SavingsCalcVersion]="2018" and [Customer - Utility]="ABC",    
If(Contains([Equipment - BuildingType],"amily"),0.184,    
If([Equipment - NominalTonnage]<25,0.139,0.105)),    
If([Customer - State]="TX" or [Customer - State]="NM",      
If(Contains([Equipment - BuildingType],"amily"),0.1212,0.1117),      
If(Contains([Equipment - BuildingType],"amily"),0.1383,0.1221)))
Formulas and functions
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    You are missing about 20 closing brackets.

    Quick Base, unlike Excel, does not need all those IFs.  Normally you just need 1.  That way you do not have to go cross eyed in matching them up.

    But also the logic ion your formula does not make sense.

    If suggest that you rewrite it like this

    IF(
    some condition is true, result 1,
    some other condition is true, result 2,
    Yet another condition is true, Result 3, Result 4)