<
<

Apply Modulo

>

Finding the remainder after division by a specified value.

>

Input

Output

35 Related tools

Table Statistic?

Any Questions?

Finding the remainder after division by a specified value. Modulo is an arithmetic operation that calculates the remainder after division. Read more about modulo on Wikipedia https://en.wikipedia.org/wiki/Modulo

The modulo of 10 divided by 3 is 1, because modulo returns the remainder after dividing one number by another.

Allows for the application of the modulo operation, useful in a variety of mathematical contexts.

  • Microsoft Excel: MOD
  • Google Sheets: MOD
  • Apple Numbers: MOD
  • Python Pandas: s % value
  • Related Words: apply modulo, calculate the remainder after division by a constant or values from another table

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?

Modulo Two Tables

Calculate the modulo operation element-wise for each cell.

modulo
Exponent Two Columns

Raises one column's values to the power of another's.

modulo
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 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.

Limit Maximum Number

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

Limit Minimum Number

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

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
>