K
kiran
Hi All,
I am recording a macro with the formula passing as follows -
=IF(AND(S2="IncidentLow",O2<=168),"Pass",
IF(AND(S2="IncidentMedium",O2<=24),"Pass",
IF(AND(S2="IncidentHigh",O2<=8),"Pass",
IF(AND(S2="IncidentUrgent",O2<=4),"Pass",
IF(AND(S2="RequestLow",O2<=600),"Pass",
IF(AND(S2="RequestMedium",O2<=120),"Pass",
IF(AND(S2="RequestHigh",O2<=40),"Pass")))))))
I am getting an error Unable to Record, can any one help please to record
this formula.
TIA
I am recording a macro with the formula passing as follows -
=IF(AND(S2="IncidentLow",O2<=168),"Pass",
IF(AND(S2="IncidentMedium",O2<=24),"Pass",
IF(AND(S2="IncidentHigh",O2<=8),"Pass",
IF(AND(S2="IncidentUrgent",O2<=4),"Pass",
IF(AND(S2="RequestLow",O2<=600),"Pass",
IF(AND(S2="RequestMedium",O2<=120),"Pass",
IF(AND(S2="RequestHigh",O2<=40),"Pass")))))))
I am getting an error Unable to Record, can any one help please to record
this formula.
TIA