[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Time formula

Posted on 2012-03-25
2
Medium Priority
?
336 Views
Last Modified: 2012-03-26
=IF(D2<>"",IF(ISNA(MATCH(A2,$J$2:$J$5,0)),"",LOOKUP(1-(VLOOKUP(A2,$J$2:$K$5,2)-D2)/D2,{0,0.5,0.75,1},{"< 50%","< 75%","< 100%","Fail"})),"")

In the attached sheet I have times reassigned and closed plus a table of times we have to resolve. Anything over those times fails, anything within those times I need % within those time to resolve. To make it easy for me to read, I wanted anything within 50% of the time to read < 50% any thing before 75% and after 50% to read < 75% and anything before 100% to read < 100%. I hope this was not to confusing. Thanks in advance for the help.
sample-sheet.xlsx
0
Comment
Question by:Edward Pamias
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 2000 total points
ID: 37765217
Try this formula in E2 copied down

=IFERROR(LOOKUP(D2/VLOOKUP(A2,$J$2:$K$5,2,0),{0,0.5,0.75,1;"< 50%","< 75%","< 100%","Fail"}),"")

see attached

regards, barry
sample-barry.xlsx
0
 
LVL 19

Author Closing Comment

by:Edward Pamias
ID: 37766523
Thank you! This is GOOD!
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question