Error Recording Macro

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top