Windows 10: What's the best way to use If And function based on multiple criteria?

Hi,Trying to use if and function to output a certain number in D2. For instance, if a2="apple and b2="red" would like d2= .5.

:)

 

Sorting Explorer columns by multiple criteria

I also haven't seen the capability of multiple sort criteria in many versions of Windows Explorer or the later [in Win8/8.1/10] File Explorer. Each column visible can be sorted in ascending or descending order, clicking a different column changes the view strictly to that arrangement. Generally the columns are sorted alphabetically with Folders first. Compressed/zip files are usually between Folders and files except in Type where they will be at either end of the list.

 

Sorting Explorer columns by multiple criteria

Interesting, I didn't know about the SHIFT-click. However, in this scenario I believe the original screenshot is correct behavior. I even tried this on Win7 and it works the same way.

When you first click on Date, you sort everything by date down to seconds (or maybe smaller). Then when you SHIFT-click on Name, you add a secondary sort. That means the sort by name only factors in when the timestamps are exactly the same.

So like in the OP, I sort by Date descending. I deliberately modified the seconds in the folder timestamps for illustration.




Then SHIFT-click on Name. Folders move to the top for some reason. Note that HP and Maxthon3Cache have the exact same modify time - so they are sorted by Name ascending.





I SHIFT-click on Name again and now HP and Maxthon3Cache are sorted by Name descending.

 

Sorting Explorer columns by multiple criteria

I think you may want to press shift. This is sorted by date and default A --> Z order within that.





and then shift left click on Name to sort backwards by name Z --> A (within original sort by date - check 22-Jul-2017 17:16).





If that doesn't work you could select a date range and then sort within that perhaps