| =SUM(A1:A10) | Adds all numbers in cells A1 through A10 |
| =AVERAGE(A1:A10) | Calculates the average of cells A1 through A10 |
| =IF(A1>10, "Yes", "No") | Returns Yes if A1 is greater than 10, else No |
| =COUNT(A1:A10) | Counts numeric entries in range |
| =COUNTA(A1:A10) | Counts all non-empty cells |
| =IFERROR(A1/B1, "Error") | Handles errors in formulas |
| =MAX(A1:A10) | Returns the largest number in the range |
| =MIN(A1:A10) | Returns the smallest number in the range |
| =LEN(A1) | Counts the number of characters in a cell |
| =TRIM(A1) | Removes extra spaces from text |
| =CONCAT(A1, B1) | Joins two values |
| =NOW() | Returns current date and time |
| =TODAY() | Returns today’s date |
| =LEFT(A1, 4) | Returns first 4 characters |
| =RIGHT(A1, 4) | Returns last 4 characters |
| =MID(A1,2,3) | Returns 3 characters from position 2 |
| =VLOOKUP("ID", A2:B10, 2, FALSE) | Vertical lookup in a table |
| =HLOOKUP("Q1", A1:D2, 2, FALSE) | Horizontal lookup in a table |
| =INDEX(A1:C3, 2, 2) | Returns value from specific row and column |
| =MATCH(25, A1:A10, 0) | Returns position of value in range |
| =ROUND(A1, 2) | Rounds number to 2 decimal places |
| =AND(A1>10, B1<5) | Returns TRUE if both conditions are true |
| =OR(A1>10, B1<5) | Returns TRUE if any condition is true |
| =NOT(A1=10) | Returns opposite of condition |
| =PROPER(A1) | Capitalizes first letter of each word |
