<
<

Limit Maximum Number

>

Clip the maximum value of a table to a specified threshold.

>

Input

Output

38 Related tools

Video Tutorial?

Table Statistic?

Any Questions?

Clip the maximum value of a table to a specified threshold. Maximum is the largest value in a set of numbers. Read more about maximum on Wikipedia https://en.wikipedia.org/wiki/Maximum_and_minimum

6 is the maximum value in the set [2, 4, 6].

This tool is useful when you need to limit data to a specific maximum value, such as setting a cap on salaries, bonuses, or discounts in a financial analysis, or removing outliers in a statistical analysis.

  • Microsoft Excel: MAX
  • Google Sheets: MAX
  • Apple Numbers: MAX
  • Python Pandas: s.clip(upper=value)
  • Related Words: clip, limit, cap, upper bound, maximum

This is normal for a web based application. We recommend uploading data up to 6000 columns and rows. If you encounter lag, you can reduce the sheet size.

There is a fullscreen button on the top right side of the input table. You can also download the table offline to edit with excel which has bigger screen sizes.

You can leave a message here.

Why SickSheet?

🌎
Access Anywhere

Compatible with any browser on any systems. No installation needed.

💸
Free to Use

Use over 300+ tools for free. No registration or credit card asked.

🧸
No Code

Complete all process without writing a single line of code.

💡
Intuitive Edit

Editing tables feels like in Excel. No learning curve needed.

💾
Instant Download

Click to download 10+ Spreadsheet formats and continue edit in Excel.

🕵️‍♂️
Super Private

Nothing is sent to the server. All data are operated on the client-side.

Related Tools?

Discover N Largest Number

Finds the biggest n numbers.

maximum
Limit Minimum Number

Clip the minimum value of a table to a specified threshold.

maximum
Calculate Maximum

Computes the maximum value in each row and column.

maximum
Rolling Maximum

Computes the rolling maximum of a specified window size for a dataset.

maximum
Cumulative Maximum

Computes the cumulative maximum in a dataset up to each row or column.

maximum
Groupby Maximum

Computes the maximum value in a dataset grouped by a specified column.

maximum
Apply Addition

Add a specified number to the entre table.

Apply Subtraction

Subtract a specified number from the entire table.

Apply Multiplication

Multiple a specified number with the entire table.

Apply Division

Divide a specified number from the entire table.

Apply Absolute Function

Returning the positive value of each number.

Apply Sign Function

Map all positives to 1 and negatives to -1.

Apply Negation

Invert the numbers in a table.

Apply Modulo

Finding the remainder after division by a specified value.

Apply Logarithmic Function

Calculating the logarithm value for each number.

Apply Exponential Function

Raising each number to the power of any number.

Apply Power Function

Apply the power function using each number of the table.

Apply Root Function

Finding the square root or nth root of each number.

Apply Sine Function

Apply the sine function to numbers in a table.

Apply Tangent Function

Apply the tangent function to numbers in a table.

Apply Cosine Function

Calculating the cosine value for each number.

Apply Factorial Function

Calculating the factorial result for each number.

Apply Normalization

Scaling numbers to a common range or format like 0 and 1.

Map Text To Length

Converts each value to their text length.

Map Text To Word Count

Counts the amount of words in every cell.

Map To Percent

Convert absolute numbers to their percent numbers.

Truncate Cell

Shortens cell content to a set length like "A sentence...".

Map To Reversed

Reverse the order of letter in a text.

Map To Shuffled Character

Randomizes character order within cells.

Map To Shuffled Word

Randomizes word order within cells.

Map To Shuffled Sentence

Randomizes sentence order within cells.

Add New Line To Sentence

Appends a newline at the start of sentences.

Compute Days Until Date

Counts days from today until the specified date.

Compute Days Since Date

Counts days since the given date up to today.

Round Number

Round numbers in a table to the nearest number.

Round Up Number

Round up numbers in a table to the nearest number.

Round Down Number

Round down numbers in a table to the nearest number.

Reformat Date

Changes date entries to a different format like yyyy-mm-dd.

<
👉... other 321 tools to save you time
>