By ABS function, we can convert negative number to positive. ABS function The ABSOLUTE (ABS) function is one of the math functions in Excel. It removes the sign of a number and returns just a positive number. ABS Arguments
By ABS function, we can find distance from zero. ABS function The ABSOLUTE (ABS) function is one of the math functions in Excel. It removes the sign of a number and returns just a positive number. ABS Arguments
By using MMULT function, we can count a specific record in the table. For example, in the below table, How many people weigh is more than 230 kg? Name Age Height Weigh Olivia 25 210 180 Noah 25 205 235 Oliver 27 195 205 Elijah 22 198 185 James 29 199 231 William 29 201 240 Benjamin […]
We want the number 256.423 to be rounded to one decimal place. We use the following formula: How to round to 2 decimals in Excel? We want the number 256.423 to be rounded to two decimal place. We use the following formula: ROUND function The ROUND function is one of the math functions of Excel. It Rounds a number to a […]
Many people store essential, valuable, confidential, and official projects and data in Excel. Due to the importance of Excel files, users can protect their data with a password. But for any reason, you may not have access to the password, or you may have forgotten the password; Do not worry! There are methods by which […]
We can extract Values greater or smaller than a certain number. For example, in the table above, we want to know Who is taller than 201? FILTER function The FILTER function is one of the Lookup & reference functions of Excel. It extracts all record from the database that matches the specified conditions. FILTER Arguments FILTER(array, include, [if_empty]) FILTER function has 3 […]
By using FILTER function, we can extract a specific record from table in excel. For example, in the table below, we want to know how old is benjamin? Name Age Height Weight Olivia 25 210 180 Noah 25 205 235 Oliver 27 195 205 Elijah 22 198 185 James 29 199 231 William 29 201 240 Benjamin […]
We can filter multiple criteria in Excel in different ways: logical AND operator : In this case, we use the multiplication operator (*) to return all the values in the range of our array. logical OR operator : In this case, we use the multiplication operator (+) to return all the values in the range of our array. FILTER function The FILTER function […]
In the following example, as you can see in the photo, Count specific words in a range can be identified by the EXACT and SUMPRODUCT functions. EXACT function The EXACT function is one of the TEXT functions of Excel. It checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. EXACT arguments […]
In the following example, as you can see in the photo, comparing one Text string with a List of Cells can be identified by the EXACT function. EXACT function The EXACT function is one of the TEXT functions of Excel. It checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. […]