Hi All, I am trying to club the below four conditions using OR to have a single one which applies on a column but I am getting syntax error. =IF(OR([EMP Level]="G",[EMP Level]="H"),SUM(([Shift B]*200),([Shift C]*400)),"") =IF(OR([EMP Level]="E",[EMP Level]="F"),SUM(([Shift B]*200),([Shift C]*475)),"") =IF(OR([EMP Level]="D",[EMP Level]="C"),SUM(([Shift B]*200),([Shift C]*550)),"") =IF([EMP Level]="B",SUM(([Shift B]*200),([Shift C]*700)),"") I want to club them so that the if state checks all the conditions and returns a result, please help… ThanksManish

Got it fixed.... =IF(OR([EMP Level]="G",[EMP Level]="H"),SUM(([Shift B]*200),([Shift C]*400)),IF(OR([EMP Level]="E",[EMP Level]="F"),SUM(([Shift B]*200),([Shift C]*475)),IF(OR([EMP Level]="D",[EMP Level]="C"),SUM(([Shift B]*200),([Shift C]*550)),IF([EMP Level]="B",SUM(([Shift B]*200),([Shift C]*700))))))Manish