How to Find Minimum and Maximum Values in a Range ?

General discussion on OpenOffice Calc and its spreadsheets.

How to Find Minimum and Maximum Values in a Range ?

Postby Tansenn » Tue Jul 29, 2014 9:36 am

Hello,

In one table I am trying to find the maximum value in a range on another table. Then do the same thing in a different cell except to find the minimum in the same range. Since there is no function to find a maximum or minimum value in a range, how do I do this? I need to do it without sorting the original table. The data are all numbers with two decimal places.

Thanks
Tansenn
 
Posts: 28
Joined: Tue Mar 25, 2014 6:27 am

Re: How to Find Minimum and Maximum Values in a Range ?

Postby FoxalTO » Tue Jul 29, 2014 12:14 pm

Hello,

Assuming your range is A1:A14, the following formulas should work:

Maximum --> =MAX(A1:A14)

Minimum --> =MIN(A1:A14)

Hope this helps...
Thanks,
FoxalTO
 
Posts: 26
Joined: Tue Mar 25, 2014 6:25 am


Return to OpenOffice.org Calc

Who is online

Users browsing this forum: Google [Bot] and 1 guest

cron