khalid79m
06-25-2009, 01:40 AM
I currently have this formula
'Call_Activity_Check
With Range("Call_Activity_Check")
.FormulaR1C1 = _
"=IF(Call_Activity_Calc=""O"",""Fail"",IF(Call_Activity_Calc=""OO"",""Fail"",IF(Call_Activity_Calc=""OOO"",""Fail"",IF(Call_Activity_Calc=""OOOO"",""Fail"",IF(Call_Activity_Calc=""OOOOO"",""Fail"",""Pass"")))))"
.Locked = True
'.Value = .Value
.EntireColumn.Hidden = True
End With
I want to simplfy it that if Call_Acticity_Calc contains and O then fail, pass. can anyone assist ?
'Call_Activity_Check
With Range("Call_Activity_Check")
.FormulaR1C1 = _
"=IF(Call_Activity_Calc=""O"",""Fail"",IF(Call_Activity_Calc=""OO"",""Fail"",IF(Call_Activity_Calc=""OOO"",""Fail"",IF(Call_Activity_Calc=""OOOO"",""Fail"",IF(Call_Activity_Calc=""OOOOO"",""Fail"",""Pass"")))))"
.Locked = True
'.Value = .Value
.EntireColumn.Hidden = True
End With
I want to simplfy it that if Call_Acticity_Calc contains and O then fail, pass. can anyone assist ?