Scribd
Upload
49 views2 pages

Excell Forms

The document provides a comprehensive list of basic formulas, statistical and math formulas, text functions, date and time functions, and logical and information functions used in spreadsheet applications. Each formula is accompanied by a brief description of its purpose and functionality. This serves as a quick reference guide for users to perform various calculations and data manipulations.

Uploaded by

banitobenzane7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
49 views2 pages

Excell Forms

The document provides a comprehensive list of basic formulas, statistical and math formulas, text functions, date and time functions, and logical and information functions used in spreadsheet applications. Each formula is accompanied by a brief description of its purpose and functionality. This serves as a quick reference guide for users to perform various calculations and data manipulations.

Uploaded by

banitobenzane7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

✅ Basic Formulas:

1. =SUM(A1:A10) → Adds values in a range.


2. =AVERAGE(A1:A10) → Calculates the average.
3. =MAX(A1:A10) → Returns the highest value.
4. =MIN(A1:A10) → Returns the lowest value.
5. =COUNT(A1:A10) → Counts numeric values.
6. =COUNTA(A1:A10) → Counts all non-empty cells.
7. =IF(A1>10,"High","Low") → Returns "High" or "Low" based on a condition.
8. =IFERROR(A1/B1,"Error") → Avoids division by zero error.
9. =VLOOKUP(100,A2:C10,2,FALSE) → Looks for a value in the first column.
10. =INDEX(A1:C10,3,2) → Returns the value at row 3, column 2.

Statistical and Math Formulas:

1. =MEDIAN(A1:A10) → Returns the median value.


2. =MOD(A1,B1) → Returns the remainder of division.
3. =SQRT(A1) → Calculates the square root.
4. =PRODUCT(A1:A10) → Multiplies values.
5. =POWER(A1,B1) → Raises A1 to the power of B1.
6. =ROUND(A1,2) → Rounds to 2 decimal places.
7. =ROUNDDOWN(A1,0) → Rounds down.
8. =ROUNDUP(A1,0) → Rounds up.
9. =SUMIF(A1:A10,">5") → Sums values greater than 5.
10. =AVERAGEIF(A1:A10,">5") → Averages values that meet the condition.

� Text Functions:

1. =LEFT(A1,5) → Extracts the first 5 characters.


2. =RIGHT(A1,5) → Extracts the last 5 characters.
3. =MID(A1,2,4) → Extracts 4 characters starting from position 2.
4. =UPPER(A1) → Converts text to uppercase.
5. =LOWER(A1) → Converts text to lowercase.
6. =PROPER(A1) → Capitalizes the first letter of each word.
7. =CONCAT(A1,B1) → Joins text from cells.
8. =TEXT(A1,"$#,##0.00") → Formats numbers as currency.
9. =FIND("e",A1) → Finds the position of "e".
10. =SUBSTITUTE(A1,"Old","New") → Replaces words in text.

⏰ Date and Time Functions:

1. =TODAY() → Returns the current date.


2. =NOW() → Returns the current date and time.
3. =DAY(A1) → Returns the day from a date.
4. =MONTH(A1) → Returns the month from a date.
5. =YEAR(A1) → Returns the year from a date.
6. =DAYS360(A1,A2) → Calculates days using a 360-day calendar.
7. =DATEDIF(A1,A2,"y") → Returns the number of years between two dates.
8. =HOUR(A1) → Returns the hour from a time.
9. =MINUTE(A1) → Returns the minutes from a time.
10. =SECOND(A1) → Returns the seconds from a time.

Logical and Information Functions:

1. =ISERROR(A1) → Checks for an error.


2. =ISTEXT(A1) → Checks if the value is text.
3. =ISNUMBER(A1) → Checks if the value is a number.
4. =NOT(A1) → Reverses a logical value.
5. =OR(A1>5,A2<3) → Returns TRUE if any condition is true.
6. =AND(A1>5,A2<3) → Returns TRUE if both conditions are true.
7. =IF(AND(A1>5,A2<3),"OK","NOK") → Conditional with multiple checks.
8. =MATCH(50,A1:A10,0) → Returns the position of a value.
9. =CHOOSE(3,"A","B","C") → Returns the 3rd value ("C").
10. =TRANSPOSE(A1:A10) → Converts rows to columns and vice versa.

You might also like