Hi,
I have a sheet that needs to display whether particular service response times are within accepted SLA levels or not. I need to be able to accomplish the following:
IF A1 = "Service1" THEN B1 = "24 hours(In time format)"
ELSE
IF A1 = "Service2" THEN B1 = "72 hours(In time format)
Thanks in advance
Bookmarks