New Formula

[vincentharris]

I have a spreadsheet that reads as follows:

Status Tier OpenDate ResolveDate SLA ServiceLevel

I wrote the following formula for Service Level and it worked just fine:

=IF(F2="Tier 3","Next Business Day",IF(F2="Tier 4","3 Business Days",IF(F2="Tier 2","4 Hours",IF(F2="Tier 1","8 Hours", IF(F2= "IMAC-D","5 Business Days")))))


What I am wanting to do is create a formula for SLA that when the OpenDate and ResolveDate is entered the SLA will populate to Missed or On Time.

For example, if a Tier is 3 which means the Service Level is Next Business Day and the OpenDate is 6/16/09 9:28 AM and the ResolveDate is 6/17/09 4:25 PM I need to have a formula in place to show On Time or Missed. Also I need to have a formula to reflect if a ticket was resolved on the weekend to also show whether it was Missed or On Time.

 

[SkipVought]

Hi,

Check out Data > List - Create List

Your formula(s) will be propogated to the new row being entered.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vincentharris]

In Excel....where do I find Data> List > Create List?

 

[SkipVought]

What version of Excel?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vincentharris]

I am using 2007 version of Excel

 

[xlhelp]

Insert Tab, Tables Group, Table

I don't particularly care about apathy

 

[vincentharris]

I am confused...I see INSERT at the tool bar but not sure where to go from that point.

 

[SkipVought]

Its NOT the toolbar. It is the Insert TAB.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[vincentharris]

On the keyboard?? I see insert on the keyboard but still dont know where to go next. I also see INSERT next to HOME. Still not sure what to do next.

 

[SkipVought]

In the Excel 2007 TAB HEADINGS, is a tab called INSERT. At Above the sheet headings.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

I have to ask. Are you sure you are using Excel 2007?

I don't particularly care about apathy

 

[vincentharris]

Yes..I am using Excel 2007..I am not sure where to look. I see INSERT at the top between HOME and Page Layout. I am not sure what to look for when you say INSERT.

 

[xlhelp]

LOL. Too funny. The insert that you see is called the "INSERT TAB". There should be a table group under it. Then click (press your left mouse button) on Table to create a list.

I don't particularly care about apathy