When Using Advanced Filtering on a Column That Contains, for Example

When using Advanced Filtering on a column that contains, for example, the cost of lodgings at various places and you select the criteria shown, what will your results be?Cost is greater than 500 And is less than 100

A) No entries will be in the results because a value cannot be both greater than 500 and less than 100 at the same time .
B) The results will contain all the cells with values over 500 and the cells with values under 100 .
C) All entries will be in the results because every cell meets at least one of the criteria .
D) Nothing will happen; this is an unacceptable filter .