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.

Comments

How Many Chemicals are available in a cup of Coffee?

A cup of Coffee has 1000 types of chemical, including antioxidant. Just to mention those chemicals are labeled as "Aroma Chemical Compound", which is capable of stimulating your sense of smell. Now, you probably know when you go to a fragrance store their Sales Associates ask you to smell coffee beans before smelling fragrance or cologne samples. If you are interested planning to own a coffee shop business you may want to Click Here!

Where Was the World's First Fully Equipped Hospital? 🏥

The title of the first fully equipped hospital belongs to two major historical milestones, depending on how you define its features: 370 CE: The Basilias (Caesarea, Modern-Day Turkey) Widely recognized as the world's first true public general hospital . The Setup: Founded by Saint Basil, it was a massive complex with specialized wings, including a general medical hospital, an isolation ward for lepers, an orphanage, and a hospice. The Care: It moved away from purely spiritual healing by hiring a permanent staff of salaried, professional physicians and nurses to treat the public for free. 805 CE: The Baghdad Bimaristan (Modern-Day Iraq) The true blueprint for the integrated modern hospital system , commissioned by Caliph Harun al-Rashid. The Setup: A highly advanced facility divided into distinct medical departments (internal medicine, orthopedics, ophthalmology, and psychiatry) alongside an on-site pharmacy. The Protocol: It pioneered modern administrative standards, requiring...

5 Household Items to Stop Buying in 2026!

We all love a smart home upgrade, but 2026 is all about minimalism, cost efficiency, and skipping the clutter . If you want to protect your wallet and your storage space this year, here are 5 things to cross off your shopping list: 1. Cheap, Proprietary Inkjet Printers Low upfront costs usually hide a massive trap: astronomically expensive ink cartridges equipped with software locks that block third-party brands. The Fact: Over a single year, replacing proprietary ink can easily cost double the original price of the printer. The Alternative: Invest in a monochrome laser printer or a tank-based printer. They cost a bit more upfront but offer incredible page yields and won't dry out. 2. Single-Purpose Kitchen Gadgets From electric avocado slicers to specialized egg-bite cookers, single-use appliances are major space-wasters that are notoriously difficult to clean. The Fact: Professional organizers consistently rank niche kitchen gadgets as a top source of household clutter and bu...

Just Facts

Search This Blog