Skip to main content

The most 10 commonly used Microsoft Excel FORMULAS!


 

1.    SUM: Calculates the sum of a range of cells. For example, =SUM(A1:A10) will add up the values in cells A1 through A10.


2.       AVERAGE: Calculates the average of a range of cells. For example, =AVERAGE(A1:A10) will calculate the average of the values in cells A1 through A10.

 

3.       MAX: Returns the largest value in a range of cells. For example, =MAX(A1:A10) will return the largest value in cells A1 through A10.

 

4.       MIN: Returns the smallest value in a range of cells. For example, =MIN(A1:A10) will return the smallest value in cells A1 through A10.

 

5.       COUNT: Counts the number of cells in a range that contain numeric values. For example, =COUNT(A1:A10) will count the number of cells in cells A1 through A10 that contain numeric values.

 

6.       COUNTIF: Counts the number of cells in a range that meet a certain condition. For example, =COUNTIF(A1:A10, ">5") will count the number of cells in cells A1 through A10 that are greater than 5.

 

7.       IF: Returns one value if a condition is true and another value if it is false. For example, =IF(A1>5, "Yes", "No") will return "Yes" if the value in cell A1 is greater than 5, and "No" if it is not.

 

8.       CONCATENATE: Joins two or more strings of text together. For example, =CONCATENATE(A1, " ", B1) will join the text in cell A1 and B1 with a space in between.

 

9.       VLOOKUP: Searches for a value in the first column of a table and returns a corresponding value in the same row from a specified column. For example, =VLOOKUP(A1, Table1, 2, FALSE) will search for the value in cell A1 in the first column of Table1 and return the corresponding value from the second column.

 

10.   INDEX/MATCH: A combination of two formulas that searches for a value in a column and returns a corresponding value in the same row from a different column. For example, =INDEX(Table1[Column2],MATCH(A1,Table1[Column1],0)) will search for the value in cell A1 in the column named Column1 of Table1 and return the corresponding value from the column named Column2.

Labels:

Comments

Post a Comment

Popular posts from this blog

Who Designed Universal Product Code?

A n I.B.M engineer, George Lauerer designed Universal Product Code as it visible on products we buy. Mr. Lauerer was asked to develop universal Product Code base on bull-eyed shaped code combination invented by N. Joseph Woodland in 1940. The purpose was that Universal Product Code would be printed on food labels and can be easily compatible with scanners, which was developed later on. Mr. George Lauerer, saw problem with the round shaped code, so he came up with the vertical shaped one that we see on food labels today! Universal Product Code (UPC) become available for scanners at the check out counters in after 1973.  So, next time if you someone test your I.Q and asked who came up with universal Product Code, make sure you say, " Its George Lauerer !!!"  Source:  "Who Made That Universal Product Code?"< http://www.nytimes.com/2013/01/06/magazine/who-made-that-universal-product-code.html?_r=0>
Post a Comment
Further Reading

The Return of the Travel Ban – What You Need to Know

President Donald Trump has once again put immigration policy at the forefront, announcing an expanded travel ban that restricts entry for citizens from 12 countries and imposes limitations on those from seven others. This move echoes a significant policy from his first term and is already generating considerable discussion and concern. Facts: Expanded Scope: The new ban targets citizens from 12 countries, with restrictions for an additional seven. While the exact list hasn't been fully detailed across all reports, several sources mention Afghanistan, Burma, Chad, Congo, Cuba, Haiti, Iran, Laos, Libya, Somalia, Sudan, Venezuela, and Yemen as being on the restricted or banned list.   National Security Justification: The administration cites national security concerns, including "terrorism-related" and "public-safety" risks, as well as high rates of visa overstays and "deficient" screening procedures in the affected countries. Tied to Recent Events: Pr...
Post a Comment
Further Reading

The Most Expensive Video Games Ever Made

The cost of developing and marketing a AAA (triple-A) video game has skyrocketed over the past couple of decades, often rivaling Hollywood blockbuster movie budgets. These figures often include not just the initial development, but also ongoing live-service support, marketing campaigns, and sometimes even the costs of engine development. It's challenging to get exact, officially confirmed figures, as companies are often tight-lipped about their budgets. However, based on various reports and estimates, here are some of the contenders for the most expensive games ever made: Grand Theft Auto VI (Upcoming): While not yet released, early estimates and rumors place its budget in the staggering range of $1 to $2 billion . If accurate, this would make it by far the most expensive video game ever. Genshin Impact: This live-service phenomenon from miHoYo has an estimated total cost of over $900 million (potentially nearing $1 billion with inflation) , primarily due to its ongoing develo...
Post a Comment
Further Reading