Results 1 to 4 of 4

to show "within SLA" if days between dates within SLA

Threaded View

  1. #1
    Registered User
    Join Date
    11-09-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    20

    to show "within SLA" if days between dates within SLA

    Hi, I have a spreadsheet which shows the number of days between start and finish for different solution types. I have 6 different solution types:

    P1 5 days
    P2 10 days
    P3 15 days
    PP1 5 days
    PP2 10 days
    PP3 15 days
    These are all in one column for different customers and I need an IF statement in the "Within SLA" column to say that if its "P1" in one column and >=5 days then its "within SLA" and if <6 days then "sla breach" and in the same statement need to say if tis "P2" in the column and >=10 days then its "within SLA" and if <11 days then "Sla breach" etc for the different scenarios above?
    I have tried many different if statments but none seem to be working?
    I really hope someone can help ;-)

    I have attached an example file
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1