The Upper bound limit is 90, lower bound limit is -100. If a value is inputted (not through user but through a test) if the value is greater than 90 return 90. If the value is lower than -100 return -100. If the value is 0 return -1000.
Max Function
Statistical function is of many categories. One of them is a MAX function. The MAX function returns the largest value from the list of arguments passed to it. MAX function always ignores the empty cells when performing the calculation.
Power Function
A power function is a type of single-term function. Its definition states that it is a variable containing a base value raised to a constant value acting as an exponent. This variable may also have a coefficient. For instance, the area of a circle can be given as:
The Upper bound limit is 90, lower bound limit is -100. If a value is inputted (not through user but through a test) if the value is greater than 90 return 90. If the value is lower than -100 return -100. If the value is 0 return -1000.
Step by step
Solved in 3 steps with 2 images
