modelsbytalias - Tumblr blog

[modelsbytalias]

Mastering Advanced Excel Functions: A Deep Dive into XLOOKUP, INDEX, and More

Microsoft Excel stands as a powerful tool with a plethora of functions designed to streamline data analysis and manipulation.

XLOOKUP and VLOOKUP Example:

Traditionally, VLOOKUP has been a staple for searching and retrieving data in Excel. However, the introduction of XLOOKUP has brought a more flexible and efficient alternative. XLOOKUP allows users to search a range, find the exact match, and return corresponding values. XLOOKUP and vlookup example:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Suppose we have a table with employee information, and we want to find the department of a specific employee with ID 101. The XLOOKUP version would look like this:

=XLOOKUP(101, A2:A10, B2:B10, "Not Found")

This XLOOKUP formula is more straightforward and eliminates the need for counting columns.

XLOOKUP with Multiple Criteria:

One significant advantage of xlookup with multiple criteria is its ability to handle multiple criteria without the need for complex workarounds. Let's consider a scenario where we want to find the salary of an employee in a specific department:

=XLOOKUP (1, (A2:A10=101)*(B2:B10="HR"), C2:C10, "Not Found")

Here, xlookup multiple criteria seamlessly incorporate using array multiplication, providing a concise and powerful solution.

INDEX and MATCH with Multiple Criteria:

The combination of index match multiple criteria in INDEX and MATCH functions is another powerful tool for handling multiple criteria scenarios. Suppose we want to find the project code for an employee in a specific department:

=INDEX (D2:D10, MATCH (1, (A2:A10=101)*(B2:B10="HR"), 0))

In this example, MATCH, combined with array multiplication, efficiently handles multiple criteria, while INDEX retrieves the corresponding project code.

MOD Function in Excel:

The mod function excel, it returns the remainder of a division operation. It finds applications in scenarios where cyclical patterns or repetitions are involved. For instance, to highlight every third row in a dataset:

=MOD (ROW (),3)=0

This formula, applied as a conditional formatting rule, would highlight every third row.

Smallest Function in Excel:

The smallest function in excel (SMALL) is handy for retrieving the nth smallest value from a dataset. If we have a list of scores and want to find the third smallest score:

=SMALL (A2:A10, 3)

This formula returns the third smallest score from the specified range.

Excel INDEX Function:

Excel index function is versatile and can be used for various purposes, such as retrieving values from a specified location or creating dynamic ranges. For example, to dynamically reference a range based on a category selection:

=INDEX ($B$2:$B$10,MATCH(G2,$A$2:$A$10,0))

Here, INDEX-MATCH combination dynamically fetches the values based on the selected category.

TODAY Function in Excel:

Excel today function simplifies date-related calculations by automatically returning the current date. For instance, to calculate the age of an individual:

=TODAY ()-B2

This formula subtracts the birthdates in cell B2 from the current date, providing the age.

SUBTOTAL Function in Excel:

The SUBTOTAL function is useful for performing operations on filtered data, ensuring that calculations consider only the visible cells. For example, to find the average salary of visible rows:

=SUBTOTAL (101, C2:C10)

Subtotal function in excel calculates the average salary considering only the visible cells after applying a filter.

[modelsbytalias]

Basics of Excel Functions.

Microsoft Excel stands as a robust spreadsheet application widely employed across diverse industries for tasks like data analysis, financial modeling, and beyond. Excel's versatility derives from its capacity to execute a multitude of computations and operations through functions.

Comprehending Excel Functions In the realm of Excel, functions represent predefined formulas tailored to conduct specific calculations or tasks. Functions are meticulously crafted to simplify intricate operations, automate repetitive duties, and ensure precision within your spreadsheet. xlookup is actually the best. Functions are usually grouped and categorized according to their primary objectives, simplifying users' quest to locate the precise function they require.

Mastering the Utilization of Excel Functions The application of Excel functions is a straightforward process. Here is a stepwise guide for harnessing a function in Excel:

Cell Selection: Commence by clicking on the cell where you intend to display the outcome of your function. Typically, this is the cell where the calculated value is to be showcased.Xlookup is used widely.

Introduction of the Equal Sign: Initiate the process by keying in an equal sign (=) in the chosen cell. This character signifies that you are entering a formula or function.Excel Match Function is fantastic.

Selection of a Function: Proceed to type the name of the function you wish to employ. As you begin typing, Excel presents a dropdown list of accessible functions, facilitating your search for the most suitable one. You can find Excel If Function

Opening Parenthesis: After opting for a function, enter an open parenthesis ((). This serves as the inception of the function's arguments.Countifs Function In Excel is pretty helpful.

Input of Arguments: Furnish the requisite arguments for the function. Arguments denote the values or cell references that the function employs to perform its computation. Functions may encompass varying quantities of arguments, necessitating consultation of the function's documentation for specific details. You already know that Index Match Multiple Criteria.

Closure with a Parenthesis: Finalize the function by inserting a closing parenthesis ()). Excel automatically highlights the corresponding opening parenthesis, thereby aiding the user in maintaining input accuracy.Subtotal Function In Excel has the finest results.

Execution with the Enter Key: To execute the function, press the Enter key. Excel promptly computes the result and showcases it in the selected cell. You can even use excel absolute value.

Prominent Excel Functions A set of frequently employed Excel functions can expedite your initial foray into this realm:

SUM: The Sumifs Function In Excelaggregates a selection of numbers. For instance, =SUM(A1:A5) tallies the values in cells A1 through A5.

AVERAGE: The AVERAGE function computes the mean of a range of numbers. For instance, =AVERAGE(B1:B10) derives the average of values within cells B1 through B10.

MAX and MIN: MAX retrieves the highest number within a range, whereas MIN retrieves the lowest. For instance, =MAX(C1:C8) identifies the maximum value in cells C1 through C8.

IF: The IF function proves invaluable for conditional computations. It furnishes one value if a specified condition is met and another if it isn't. For example, =IF(D1>10, "Yes", "No") displays "Yes" if the value in cell D1 surpasses 10 and "No" if it falls below.

These examples merely scratch the surface of Excel's extensive repertoire of functions. To delve deeper into the world of Excel functions, consider exploring the Excel Help feature or referring to online tutorials and guides.

[modelsbytalias]

Enhancing Productivity: The Advantages of Excel Function

Microsoft Excel, an essential tool in the corporate realm, offers an array of features and resources designed to simplify data handling, analysis, and reporting. Among the most potent and adaptable elements of Excel are its functions, which empower users to perform intricate calculations, automate procedures, and augment decision-making.

Efficient Data Analysis

Excel functions are renowned for their capacity to expedite data analysis. Functions such as excel index function, AVERAGE, and COUNT enable swift calculations on datasets, simplifying the extraction of insights and informed decision-making. These functions prove especially valuable when working with voluminous datasets, as they can spare users hours of manual computation.Excel Filter Function is used widely.

Automating Repetitive Tasks

Numerous business processes encompass repetitive tasks, such as monthly financial reporting or sales projections. Excel functions like VLOOKUP, HLOOKUP, and IF can automate these tasks. Excel Offset will help you out in all the difficult situations. By configuring functions to extract data from diverse sources, perform calculations, and generate reports, the time and effort demanded by routine activities can be substantially reduced.

Advanced Analysis

Excel functions are not confined to elementary arithmetic. Advanced functions like Excel Index Function and MATCH fundtion, along with various statistical functions, empower users to conduct intricate analyses. For instance, these functions can be employed to identify trends, outliers, and correlations within data, furnishing deeper insights for decision-makers.

Error Management

Excel functions offer a robust error-handling capacity. Functions like IFERROR and ISERROR assist in identifying and managing errors within data or formulas. This ensures that calculations remain robust and dependable, even when dealing with irregular data.

Customization

Excel functions support personalized reporting and analysis. Functions like Excel Concatenate and TEXT permit the amalgamation and formatting of data in a manner tailored to specific requirements. Whether the task is to create custom reports, labels, or financial statements, Excel functions provide the flexibility to tailor outputs accordingly.

Integration with External Software

Excel is frequently employed in tandem with other software and platforms. Functions facilitate data interchange and integration with external sources. For example, functions can be employed to import data from databases, websites, or other applications, bolstering data management capabilities.Excel Roundup is indeed one of the finest options.

Extensive Documentation and Support

Microsoft Excel provides thorough documentation and online resources concerning its functions. These resources encompass tutorials, forums, and official guides, accommodating users regardless of their expertise level. This ensures that users can effectively comprehend and harness Excel functions.Excel Mod Function is fantastic.

Excel functions are indispensable tools for individuals and enterprises seeking to enhance their data management, analysis, and reporting proficiencies. They deliver precision, efficiency, and automation while accommodating a wide array of tasks, ranging from elementary calculations to sophisticated data analysis. count function in excel for a specific task. By harnessing the capabilities of Excel functions, users can elevate their decision-making processes, conserve time, and optimize their business procedures. Whether in the realms of finance, marketing, or any field dealing with data, Excel functions constitute an invaluable asset for triumph and progress.

[modelsbytalias]

Excel: An Introduction and Tutorial.

Excel from Microsoft is a robust spreadsheet programme that has proven useful for both personal and professional use. Learn the fundamentals of Excel whether you're a student, a working professional, or just someone interested in improving your data management abilities. To get you started on the road to spreadsheet mastery, this article will cover Excel's essential principles and functionalities.

Getting Acquainted with Excel's User Interface

When you launch Excel, you'll see a grid of rows and columns that you may use to create cells. A unique reference, such as "A1," is assigned to each cell, where the letter stands for the column and the number stands for the row. The Ribbon is located at the top of the screen, and each of its tabs provides access to a different set of functions and tools for manipulating your data.Excel Vlookup is actually very good.

Data Input

You may start typing into a cell after clicking on it in Excel. Enter any combination of words, digits, and/or dates. Press the "Enter" key to advance to the next empty cell.Xlookup has been excellent. To make changes to the contents of a cell, double-click on it, then type in your new data and hit "Enter" again.

Cell Layout Modifications

Excel's numerous formatting tools allow you to give your numbers a polished, well-organized look. Excel Match Function will always help you. Change the font, colour, border, and orientation of your text, numbers, and dates. Choose "Format Cells" from the context menu that appears when you right-click a cell.

4.Fundamental arithmetic procedures

Excel is capable of performing arithmetic functions such as adding, subtracting, multiplying, and dividing. Add "+", subtract "-", multiply "*", and divide "/" to perform basic mathematical operations. You can find Excel If Function easily.

Purposes

You can execute sophisticated calculations and analyses with the help of Excel's many in-built features. Standard operations consist of SUM, AVERAGE, MAX, MIN, COUNT, and IF. Hlookup is also the best. To call a function, enter "=" followed by the name of the function and any arguments it takes. As you type, Excel will offer recommendations to help you along.

Function

AutoFill is a time-saving and labor-reducing function in Microsoft Excel. Countifs Function In Excel is used widely. You may fill in neighbouring cells with a pattern or series by entering data (such as numbers, dates, or text) in a column or row, selecting the cells, and dragging the fill handle.

Refinement by Category

You can sort and filter your data to get it in order for analysis. Sumifs Function In Excel has the finest results. Select the data you want to sort and then use the "Sort A to Z" or "Sort Z to A" button on the Ribbon to arrange the columns alphabetically or numerically, respectively. You may select certain statistics to display depending on certain criteria by clicking the "Filter" button. You can find Index Match Multiple Criteria.

Graphs and Diagrams

Excel's chart and graph features make it easy to see patterns and trends in your data. To create a graph or chart from your selected data, click the "Insert" tab and pick the appropriate option from the drop-down menu. Subtotal Function in Excel is indeed outstanding. Excel's charting tools include both bar and line graphs, as well as pie charts.

[modelsbytalias]

The Mysteries of Excel's Functions.

Microsoft Excel is a popular spreadsheet program that is known for its robust features that make doing complex computations and data processing much easier. Data manipulation and insight extraction are simplified with the use of Excel functions, which are pre-built formulae that execute certain tasks.

Let's Take Apart an Excel Function

The following are the standard components of an Excel function:

For example, "SUM," "AVERAGE," or "IF" would be examples of functions.

The function's body begins with an opening pair of parentheses, denoted by "(".

Functions perform their work on something called "arguments," which might be either a value or a reference. When passing numerous arguments to a function, separate them with commas. Count Function In Excel is used widely.

The function is terminated with the closing parenthesis (")".

Syntax: There is a prescribed format or syntax for inputting each function. Excel's built-in Function Wizard (Fx)  or the Excel manual will lead you to the correct syntax for a function.

Fundamentals of Excel

Let's take a look at a handful of Excel's most useful and versatile built-in features:

SUM is used to sum a set of numbers together. Formulas should look like "=SUM(number1, number2,...)".Excel Index Function is actually fantastic.

The AVERAGE function finds the midpoint of a set of integers. "=AVERAGE(number1, number2,...)" is the correct syntax.Excel Filter Function is the best.

The MAX function returns the highest value in a set of integers. "=MAX(number1, number2,...)" is the correct syntax.Excel Sumproduct will always give you accurate results.

The MIN function takes a range of integers and returns the smallest one. To use this formula, type "=MIN(number1, number2,...)".Excel Roundup is used widely.

COUNT returns the total number of numeric cells within the specified range. The formula looks like this: "=COUNT(value1, value2,...)".Excel Offset has been outstanding.

The IF statement makes a computation dependent on whether or not a certain condition is met. "=IF(logical_test, value_if_true, value_if_false)" is the correct syntax. People generally apply Excel Concatenate.

VLOOKUP is a function that searches a table for a value in the first column and returns another value in the same row from a different column. "=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])" is the correct syntax to use. Excel Mod Function will get you the finest results.

Using the Function Wizard and AutoSum

Excel's built-in features make it easy to quickly and accurately enter formulas. You may easily insert frequently used functions like SUM and AVERAGE into selected cells by clicking the AutoSum button () on the Home tab of the Ribbon. The Function Wizard (Fx) makes it simple to look up and incorporate new functions while learning their specific syntax and needs. Choose Function Excel is excellent.

Experiment and Perform

Using Excel's functions effectively is best learned by doing. Learn the fundamentals first, and then go on to more complex formulae and functions as your confidence grows. Excel's wide range of features makes it useful for everything from simple arithmetic to complex statistical analysis.

Learning Excel's fundamentals is a first step toward maximizing your productivity with this powerful spreadsheet program. Excel's power to conduct sophisticated computations, analyze data, and simplify operations may be fully used with some time spent practicing and learning the function syntax.

[modelsbytalias]

Mastering Excel's MATCH Function: A Comprehensive Guide

Introduction

Excel is a powerhouse when it comes to data analysis and manipulation. Among its numerous functions, the MATCH function is a valuable tool for searching and locating data within a range. Whether you're a seasoned Excel user or just starting your journey with spreadsheets, understanding how to use the MATCH function can significantly enhance your data management capabilities. In this blog post, we will delve into the world of Excel's MATCH function, exploring its syntax, applications, and some advanced techniques.

Understanding the Basics

The MATCH function in Excel is primarily used to find the relative position of a specified value within a range of cells. Excel Vlookup It returns the position of the first occurrence of the value in the range, counting from either the beginning or end of the range.

Here is the basic syntax of the MATCH function

match_type (optional): This argument specifies how Excel should match the lookup_value. It can have three values:

1 (default): Finds the largest value that is less than or equal to the lookup_value.

0: Finds an exact match.

-1: Finds the smallest value that is greater than or equal to the lookup_value.

Using MATCH for Basic Lookups

Exact Match: You can use MATCH to find the exact position of a value within a range. For instance, if you have a list of products and you want to find the position of "Apples," you can use the following formula:

This formula will return the position of "Apples" in the range A1:A10.

Approximate Match: When you need to find the closest match to a value, you can use the MATCH function with match_typeset to either 1 or -1. For example, if you have a list of scores and you want to find the position of a score closest to 85, you can use:

This formula will return the position of the value in the range B1:B10 that is just less than or equal to 85.

Advanced MATCH Techniques

Handling Errors: If the MATCH function can't find the specified value in the range, it returns an error (#N/A). Excel Match Function To handle this situation gracefully, you can use the IFERRORfunction to provide a custom message or value when no match is found. Here's an example:

This formula will display "Not Found" when "Bananas" cannot be located in the range A1:A10.

Multi-Column Matches: You can use the MATCH function in combination with other functions like INDEXand MATCH to perform more complex multi-column lookups. This is incredibly useful for creating dynamic dashboards and reports.

For instance, if you have a table with product names in one column and corresponding prices in another, you can use a combination of INDEX and MATCH to retrieve the price of a specific product.

This formula will return the price of "Apples" by first finding its position and then using that position to retrieve the corresponding price.

Conclusion

Excel's MATCH function is a versatile tool that can simplify data analysis tasks and save you time when searching for specific values within a range. Whether you need an exact match or an approximate one, understanding the MATCH function's syntax and various applications can significantly boost your Excel proficiency. So, the next time you're working with large datasets or building complex spreadsheets, remember to incorporate the MATCH function into your toolkit. With practice, you'll find it to be an invaluable asset in your Excel arsenal.

[modelsbytalias]

Excel Concatenate

In today's post, we would be exploring the concatenate function and how to apply it to your data set in excel. The concatenate and Concat functions allow you combine both written texts within the formula and texts written in a separate cell. We would touch on all these in the sections to follow.

Excel Concatenate

[modelsbytalias]

Hlookup

on summary, the HLOOKUP Function instructs Excel to look for a specific value on a row and then return a value on another row but inside the same column by sliding down from that initial value in accordance with the count supplied by the user. Don't worry if this all sounds incomprehensible to you; in this piece, we'll explain the HLOOKUP function with examples to make it easier for you to comprehend.

Hlookup

[modelsbytalias]

Subtotal Function In Excel

The subtotal function is a very handy function to use when you constantly apply filter to a dataset, and you need to see results instanty. Today we take you through the workings of the SUBTOTAL Function.

[modelsbytalias]

Excel's Hidden Functions, the Key to Greater Productivity.

Microsoft Excel is a popular spreadsheet program that has become the de facto standard for many types of business and professional data management, analysis, and reporting. Excel’s functions, which are pre-made formulae meant to execute certain computations and activities, constitute the program’s backbone. Data manipulation, automation of difficult computations, and the ability to draw useful conclusions from raw data are just a few of the many advantages offered by Excel functions. This article will discuss the many ways in which Excel’s built-in capabilities may improve your work life, whether at home or in the office.

Automated systems that save time

Reliability and Stability

Accurate and reliable computations are guaranteed by Excel’s built-in functions. There is no room for human error in calculations when using specified, error-free routines. You can even use Excel Filter Function. When working with enormous datasets, where even a small mistake may have serious repercussions, this is more crucial than ever. Excel’s built-in functions ensure that users’ computations are always accurate. People also prefer Choose Function Excel.

Complex Formulas Are Simplified

Excel’s built-in functions make it easier to create sophisticated calculations. Users may take use of predefined functions to do a variety of tasks without having to manually type out complex formulae. Conditional computations and data retrieval are made much easier with the use of functions like IF, VLOOKUP, and Excel Index Function. By eliminating unnecessary complexity, both formula readability and spreadsheet upkeep are greatly enhanced.

Analysis of Real-Time Data

Conclusion

Excel functions are what make Microsoft Excel so useful for analyzing and manipulating data. Their capacity to automate previously manual processes, provide pinpoint precision, and reduce the complexity of previously convoluted calculations has a notable impact on productivity. Excel Roundup has been outstanding. Dynamic data analysis guarantees that reports and analyses are always up-to-date, and automated computation frees up users to focus on higher-value duties. Excel’s adaptability in data manipulation and analysis makes it ideal for meeting the unique requirements of each organization. Excel Concatenate is one of the finest functions.

Functions also allow for rapid summary of data, which is useful for extracting insights from massive data sets. Excel’s analytical skills and data cleansing and formatting tools both contribute to the consistency and presentation of data, while the latter facilitates improved decision-making.

In conclusion, Excel’s functions allow users from any field to make full advantage of the app’s extensive spreadsheet capabilities. Excel functions provide a broad variety of tools to simplify procedures and enhance data-driven decision-making, making them a vital asset for users worldwide who rely on Excel for financial analysis, data reporting, project management, or any other data-driven work.

[modelsbytalias]

Subtotal Function In Excel

The subtotal function is a very handy function to use when you constantly apply filter to a dataset, and you need to see results instanty. Today we take you through the workings of the SUBTOTAL Function.

Subtotal Function In Excel

[modelsbytalias]

Excel Match Function

The MATCH function can check for close and exact matches as well as partial matches using wildcards. We would explain the MATCH function in detail and provide instances of how it is used in modelling in this post.

Excel Match Function

[modelsbytalias]

Excel's Hidden Functions, the Key to Greater Productivity.

Excel functions are useful mainly because of their ability to automate both simple and complicated computations. Subtotal Function In Excel is used widely.

[modelsbytalias]

Learn How to Use Excel's Powerful Functions to Analyse and Manipulate Data.

Microsoft Excel is an industry standard for managing and analysing data as well as creating reports across a wide range of fields and specialties. Excel's functions, which are pre-made formulae meant to execute certain computations and activities, constitute the program's backbone. Automating difficult computations, analyzing enormous datasets, and deriving insights from raw data are all made much easier with the help of Excel functions. In this piece, we'll delve into Excel functions, their applications, and how they allow users to make the most of this flexible program.

Why do we need Excel Functions?

Excel functions are established formulae that aid users in completing a variety of tasks, from simple arithmetic to complex data analysis and manipulation. Xlookup is used widely. There are more than 400 purpose-built functions available in Excel. All functions must adhere to a strict syntax that combines letters, integers, and symbols to produce the desired outcomes.

Standard Excel Procedures

One of Excel's most fundamental functions is SUM, which is used to sum a set of values. Cells A1 through A10 might be added using =SUM(A1:A10). Excel Match Function is the best.

The AVERAGE function takes a set of numbers and returns their average value. If you typed =AVERAGE(B1:B5) into a spreadsheet, it would calculate the mean of the contents of cells B1 through B5. Hlookup is indeed excellent.

The COUNT function counts the number of numeric cells inside a specified range. If you typed =COUNT(C1:C100), Excel would tally up how many cells between coordinates C1 and C100 contain numbers. Countifs Function in Excel has been outstanding.

The Excel If Function, short for "if," is a strong conditional function that allows users to do varying actions depending on a given condition. This expression looks like this: =IF(condition, value_if_true, value_if_false). As an illustration, the formula =IF(A1>50, "Pass", "Fail") would return "Pass" if the value in cell A1 is larger than 50 and "Fail" otherwise.

Excel Vlookup is the fifth function on the list, and it is used to look up information in a table. It takes a value from the first column of a table and finds it in the same row in the second column, which it then returns. Example: =VLOOKUP("ProductX", A1:B100, 2, FALSE) would return the value from column B if "ProductX" was found in the range A1:B100. Sumifs Function In Excel is used widely.

Conclusion

Excel functions are what make Microsoft Excel so useful for analyzing and manipulating data. By simplifying difficult computations, these pre-built formulae aid users in their work with data. Learning Excel Index Function is the key to unlocking the full capabilities of this sophisticated spreadsheet program and turning data into insights. Excel functions provide a wide range of capabilities to satisfy your needs, from fundamental arithmetic operations to conditional statements and complex data analysis. As you explore Excel's capabilities, you'll find that the software can be used in virtually every field to facilitate more informed decision-making and better data management. Index Match Multiple Criteria is pretty easy.

[modelsbytalias]

Using Excel's Built-In Functions for Data-Driven Automation.

ConclusionExcel functions are fundamental to ExcelÕs ability to analyze and automate repetitive tasks. They enable users to efficiently execute a variety of calculations, manipulate data, make sound decisions, and retrieve data according to user-defined criteria. ExcelÕs full potential as a data analysis and decision-making tool can be accessed by making advantage of the softwareÕs many features. You can anytime use Subtotal Function in Excel. Users can save time, energy, and effort by taking use of ExcelÕs many time-saving and labor-saving features. Mastering Excel functions is a useful skill that offers up a world of possibilities for effective data administration and analysis, whether youÕre a corporate professional, analyst, or student.

Using Excel's Built-In Functions for Data-Driven Automation.

[modelsbytalias]

Index Match Multiple Criteria

In our INDEX Function post, we treated the INDEX MATCH Function combination, however that was for single criteria lookup. In this post we would be reviewing how to combine the INDEX and MATCH Functions for a multiple criteria lookup.

Index Match Multiple Criteria

[modelsbytalias]

Excel Mod Function

The MOD Function may seem bland and useless, but when combined with other functions, it has tons of uses. Let's take you through the MOD Function and how you can utilize it in your financial models.

Excel Mod Function