Thread: Urgent Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kiran kiran is offline
external usenet poster
 
Posts: 65
Default Urgent Help

Hi All,
I want a macro to given formula -

=IF(AND(A2="IncidentLow",B2<=168),"Pass",
IF(AND(A2="IncidentMedium",B2<=24),"Pass",
IF(AND(A2="IncidentHigh",B2<=8),"Pass",
IF(AND(A2="IncidentUrgent",B2<=4),"Pass",
IF(AND(A2="RequestLow",B2<=600),"Pass",
IF(AND(A2="RequestMedium",B2<=120),"Pass",
IF(AND(A2="RequestHigh",B2<=40),"Pass")))))))

Pls help

TIA