I have a spreadsheet which filters on various criteria based on location and contract renewal dates etc.
Previously, I had a simple if statement to filter on usage criteria: =IF(AY2>=2000, "GOOD", IF(AY2>=1000, "OK", IF(AY2>=0.1, "BAD", IF(AY2 >0.1, "BAD", "Nil usage" ) ) ) )
(not pretty but it worked)
I now find I need to create a more accurate filter based on other numerical criteria i.e. more than 500 hours and more than 5 tasks set and Data sent in would return GOOD
I attach an example of what I want with the data headings and rules:
I also attach an example sheet as above. I hope someone can help.HTML Code:
Thanks
Simon
Bookmarks