The use of statistical functions can be tremendously useful if we want to handle large amounts of data properly. Generally, we use formulas with functions for cells in spreadsheets, but in this post we will explain How to calculate or use the maximum and minimum function in Microsoft Word taking advantage of the versatility of the Microsoft Office suite.
Steps to calculate absolute maxima and minima in Word
We regularly use statistical functions for spreadsheets in Microsoft Excel. Despite this, you should know that it is also feasible to enter functions in a text document created from Microsoft Word. Then, We will show you step by step the procedure you must follow to calculate maximums and minimums in Microsoft Word.
In the same way, We suggest that you learn to use formulas in a spreadsheet so that you can use the functions in any Office application.
Create a table in Microsoft Word
The first step is to create a table in Microsoft Word. To do this, go to the Microsoft Word application or install Microsoft Office Online and find the tab “Insert”. Select option “Boards” and click “Insert table”.
Enter the number of rows and the number of columns the table will have. These values depend on the amount of data you want to handle to apply the maximum function Y minimums.
Insert the values in each cell
The next step is write the values in each cell of the table. These values must be numeric, since they will serve as arguments to establish the range and, therefore, successfully execute the maximum and minimum function.
Calculate or use the maximum function in Microsoft Word
Once you fill the table with their respective numerical values, put the cursor in the cell where you want to display the result and click the tab “Presentation”. In the most recent versions of Microsoft Word you must enter “Design”. Then, look for the section “Data” and click “Formula”.
Immediately, a new window will open to insert the formula into a text box. On “Formula” write the = sign. On “Number format” select value 0 and on the label “Paste function” select function “Max”. Inside the parenthesis write LEFT if the data range is to the left of the cell that will show the result or BELOW if they are in it.
Calculate or use the Minimum function in Microsoft Word
To calculate or use the minimum function in Microsoft Word, you need to follow the above step again to insert a formula into a particular cell. In the formula window, type the = sign and select the MIN function of “Paste function”.
Remember to write the position of the range in parentheses (LEFT or DOWN) or of the set of values that you are going to examine using the minimal function. To end, press “To accept”.
Is it feasible to calculate relative maxima and minima in Word?
When we talk about relative highs and lows, we mean the value, either higher or lower, that fulfills a function at a given moment.
Unfortunately, this feature is not enabled in Word.At the moment you can only insert calculation tables or search for the absolute maximum and minimum tool, In other words, only value can be calculated, is greater or less than what a function can achieve throughout its range.
The best tools to do mathematical calculations
If you find it difficult to perform mathematical calculations with office tools, or you are just looking for specific tools for the type of problems you want to fix, In this post we mention some alternatives.
GeoGebra application
This application consists of software that can perform mathematical operations of any level educational, giving you an explanation of the procedure if you wish. You can download this application on your Android device or install it on your desktop computer.
Desmos graphing calculators
This tool that we can find online, fulfills the objective of graphing ‘mathematical functions’ with some additional options that distinguish it from other programs. This one in general terms is very good, fast and accurate.
EquatIQ
It is a Google extension that facilitates the insertion, edit and interact with mathematical formulas, operations and graphics in any other program used for text in the Google search engine, like Google Docs.
The function of the maxima
Microsoft enables you to use a maximums feature from your Microsoft Office suite. This function is known as MAX and is used to obtain the highest value among a set of values or range. These values can be names, numbers, references or arrays containing numbers.
And what is more, the MAX function may require logical values and texts that refer to argument numbers. It is essential to note that the maximums function will return “0” if the arguments do not contain numeric values.
The function of minima
On the other hand, Microsoft offers the minimal function to provide the smallest value in a range that is set as a parameter to the arguments. As the maximum function, minimal function ignores logical and text values, allowing only numeric data.
The minimal function enables the use of references to indicate the arguments or directly express the values that are part of the range to examine. Those values that cannot be translated into numbers immediately are interpreted as an error and this is exactly what the function returns.
