answersLogoWhite

0

MAX. If you had a series of numbers in the range B1:B84 the following formula would show the largest of them:

=MAX(B1:B84).

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What is the formula for calculating the amplitude of a pendulum?

The formula for calculating the amplitude of a pendulum is given by the equation: amplitude maximum angle of swing.


What is the formula for calculating the amplitude of oscillation in a system?

The formula for calculating the amplitude of oscillation in a system is A (maximum displacement from equilibrium) - (equilibrium position).


What is the max speed formula for calculating the velocity of an object?

The formula for calculating the maximum speed of an object is: max speed distance / time.


What is the max voltage formula for calculating the maximum voltage in an electrical circuit?

The formula for calculating the maximum voltage in an electrical circuit is V I R, where V is the voltage, I is the current, and R is the resistance.


What is the formula for calculating mean of numbers 1 to 100?

Since you put this question in the Excel category, I will respond with an Excel formula. Assuming you put your numbers in cells A1 through A100, the formula would be:=SUM(A1:A100)/100


Why are brackets necessary when calculating the total cost of an item in Excel?

It depends on your formula, but you may need them to change the order of operations.


What is the Formula for calculating lower quartile on excel?

.25 * The Number of items in the list plus 1 equals the Item Number that is the lower quartile.


What is the excel formula for calculating surface area to include flat roof for a building that is length 60 width 160 height 30?

9600


What is the most effective Excel formula for calculating credit card payoff?

The most effective Excel formula for calculating credit card payoff is the PMT function. This function helps you determine the fixed monthly payment needed to pay off a credit card balance within a specific timeframe, taking into account the interest rate and other relevant factors.


It is a calculating method in MS excel?

Formulas and Functions.


What is the Excel credit card payoff formula for calculating the amount needed to pay off a credit card debt?

The Excel credit card payoff formula is PMT(rate, nper, -balance). This formula calculates the monthly payment needed to pay off a credit card debt within a specific time frame.


Formula for calculating gross?

GP=(sell price-cost)/sell price. In excel, whatever result you get format that cell to be a percentage by hitting the % button in the menu bar.