How to select a value from range?

[paulwebb]

Hi Guys

I have a range of values in cells C22:D36. The values are variables within the range 0.0 - 100,000.0 (always positive and numeric), can someone advise me a simple formula to return 1) the lowest and 2) the highest values from the range please?

Many thanks

Paul

 

[Aladin Akyurek]

Hi Guys

I have a range of values in cells C22:D36. The values are variables within the range 0.0 - 100,000.0 (always positive and numeric), can someone advise me a simple formula to return 1) the lowest and 2) the highest values from the range please?

Many thanks

Paul

Lowest:

=MIN(C22:D36)

Highest:

=MAX(C22:D36)

 

[paulwebb]

Many thanks Aladin, I knew I was being over-complicated in my attempts!

 

[Aladin Akyurek]

Many thanks Aladin, I knew I was being over-complicated in my attempts!

You are welcome. That happens... Thanks for providing feedback.