Error Recording Macro
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 |
All times are GMT +1. The time now is 09:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com