Hi All,
A newbie here and I am after someones help.
I have a sheet of data
Column J shows time of completion of something in hours
Row 2 - 2226.28
Row 3 - 919.30
Row 4 - 265.02
Row 5 - 24.10
Row 6 - 24.15
Row 7 - 24.01
Row 8 - 17.40
and so on
How do I show in column L (which is a blank column) something which looks at column J Row 2 and sees value 2226.28 and returns a statement of "Outside SLA"
Row 3 returns "Outside SLA"
Row 5 "Within SLA"
Row 8 "Ahead of SLA"
My parameters need to look at the hours and decided what is inside SLA (so more than 24hrs but less than 48hrs returns "within SLA", Less than 24hrs returns "Ahead of SLA", anything more than 48hrs returns "Outside SLA"
I have values in column J which exceed several thousand hours hence why the example above is so varied but the formula needs to look at the value and decide what text to return based on the criteria.
Any help someone can provide is greatly appreciated, I think I need an IF statement but am honestly not sure.
Thank you in advance
Bookmarks