Return the minimum value of the cells within another column fall between two values

Hi all I need some help,

I have a sheet with a number of columns of data, I want to create a formula (if possible) that returns the maximum value of one column of data if another columns cell values fall between two numbers and another columns cell value is above another value.

For example

A. B. C
55.6. 90. 100
76.5. 87. 500
45.3. 98. 200
66.5. 99. 1000
34.2. 66. 500

I want to return the minimum value of column A if the values in C fall between 0 and 100 and the value of column B is above 90. So on this sheet the minimum value would be
45.3

Any help would be appriciated,

Many thanks

Sorry initial typo the criteria was meant to be between 0 and 1000, will try the formula and let you know


Sent from my iPhone using Tapatalk

Additionally the second criteria could change so for example between 0 and 1000 or 1001 and 1500 etc


Sent from my iPhone using Tapatalk

Great thanks, so how do I expand that formula to include two variables in column c i.e 0-100, 101-500,501-1000?


Sent from my iPhone using Tapatalk