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

[newbieexcelgirl]

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

[Pete_UK]

You have some P7s in your list, as well as P11 - How many days should these have allocated?

Pete

[Pete_UK]

In the absence of a reply, I've assumed that P7 is for 35 days and P11 is for 55 days. If those are true, then you could put this formula in I2:

Please Login or Register  to view this content.

and then copy down.

Hope this helps.

Pete

[newbieexcelgirl]

Hi Pete,

thanks alot for replying. However I have different conditions as above for different P numbers? In the forumula above i cannot see the conditions for 5 and 10 and 15 days?

Am prob overlooking something!

For the other P numbers we just ignore them for now.

thanks