General discussion on OpenOffice Calc and its spreadsheets.
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.
- Posts: 28
- Joined: Tue Mar 25, 2014 6:27 am
Assuming your range is A1:A14, the following formulas should work:
Maximum --> =MAX(A1:A14)
Minimum --> =MIN(A1:A14)
Hope this helps...
- Posts: 26
- Joined: Tue Mar 25, 2014 6:25 am
Return to OpenOffice.org Calc
Who is online
Users browsing this forum: No registered users and 1 guest