X
excel.rean.meWork faster in Excel
Downloads•Beginner
Share on X (Twitter)Share on LinkedInShare on FacebookShare on TelegramShare on Reddit

Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)

Free download PDF cheatsheet learn 50 popular Excel formulas in Khmer language for beginner.

Advertisement

Hello everyone! Today I share free PDF eBook 50 Popular Excel Formulas (prepared by Mr. Meng Hann). This book include basic calculation, text format, date & time, logical condition, and lookup function for beginner to practice at home easily.

50 Excel formulas PDF Book Cover

📚 What Inside This PDF Book?

This book contain 5 main group of Excel formulas:

  1. Basic Calculation Formulas: SUM, AVERAGE, COUNT, COUNTA, MAX, MIN, ROUND, etc.
  2. Basic Text Formulas: CONCAT, LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER, etc.
  3. Basic Date & Time Formulas: TODAY, NOW, DATE, YEAR, MONTH, DAY, TIME, DAYS, etc.
  4. Basic Logical & Conditional Formulas: IF, AND, OR, NOT, IFERROR, COUNTIF, SUMIF.
  5. Basic Information & Lookup Formulas: ISNUMBER, ISTEXT, ISBLANK, MATCH.

💡 Related Tutorials & Resources

If you want learn more Excel formulas, check these free guide:

📋 50 Excel Formulas Cheatsheet Summary Table

Advertisement

Below is quick preview table of 50 formulas inside the PDF file:

1. Basic Calculation Formulas

#FormulaDescriptionExample
1=SUM(range)Sum all numbers in range=SUM(A1:A5)
2=AVERAGE(range)Get average value=AVERAGE(B1:B4)
3=COUNT(range)Count cells with numbers=COUNT(A1:C5)
4=COUNTA(range)Count all non-empty cells=COUNTA(A1:A10)
5=COUNTBLANK(range)Count blank cells=COUNTBLANK(B1:B10)
6=MAX(range)Find highest value=MAX(C1:C10)
7=MIN(range)Find lowest value=MIN(C1:C10)
8=PRODUCT(range)Multiply numbers in range=PRODUCT(A1:A3)
9=MOD(number, divisor)Get remainder of division=MOD(10, 3)
10=ROUND(number, num_digits)Round number to decimal digits=ROUND(15.678, 2)
11=ABS(number)Get absolute value=ABS(-25)
12=INT(number)Get integer part only=INT(8.95)
13=SQRT(number)Get square root=SQRT(16)
14=POWER(number, power)Calculate power of number=POWER(5, 2)

2. Basic Text Formulas

#FormulaDescriptionExampleResult
15=CONCAT(text1, text2, ...)Join text from multiple cells=CONCAT("Sok ", "Chea")Sok Chea
16=LEFT(text, [num_chars])Cut characters from left=LEFT("Excel", 2)Ex
17=RIGHT(text, [num_chars])Cut characters from right=RIGHT("Excel", 3)cel
18=MID(text, start, num)Cut characters from middle=MID("Microsoft", 6, 4)soft
19=LEN(text)Count length of characters=LEN("Khmer")5
20=TRIM(text)Remove extra spaces=TRIM(" Hello ")Hello
21=UPPER(text)Convert text to UPPERCASE=UPPER("apple")APPLE
22=LOWER(text)Convert text to lowercase=LOWER("WORK")work
23=PROPER(text)Convert first letter to uppercase=PROPER("john doe")John Doe
24=REPLACE(old, start, num, new)Replace text by position=REPLACE("2024", 3, 2, "26")2026
25=SUBSTITUTE(text, old, new)Replace old word with new word=SUBSTITUTE("I like A", "A", "B")I like B
26=REPT(text, number_times)Repeat text multiple times=REPT("*", 5)*****
27=EXACT(text1, text2)Compare two text exact match=EXACT("A", "a")False

3. Basic Date & Time Formulas

#FormulaDescriptionExampleResult
28=TODAY()Get current date=TODAY()30/05/2026
29=NOW()Get current date & time=NOW()30/05/2026 15:20
30=DATE(year, month, day)Create date serial=DATE(2026, 5, 30)30/05/2026
31=YEAR(serial_number)Extract year number=YEAR("30/05/2026")2026
32=MONTH(serial_number)Extract month number=MONTH("30/05/2026")5
33=DAY(serial_number)Extract day number=DAY("30/05/2026")30
34=TIME(hour, minute, second)Create time serial=TIME(14, 30, 0)2:30 PM
35=HOUR(serial_number)Extract hour number=HOUR("14:30:00")14
36=MINUTE(serial_number)Extract minute number=MINUTE("14:30:00")30
37=SECOND(serial_number)Extract second number=SECOND("14:30:05")5
38=WEEKDAY(serial_number)Get day of week (1=Sun, 7=Sat)=WEEKDAY("30/05/2026")7
39=DAYS(end_date, start_date)Calculate total days between dates=DAYS("10/05/2026", "01/05/2026")9

4. Basic Logical & Conditional Formulas

#FormulaDescriptionExampleResult
40=IF(test, true, false)Check condition TRUE/FALSE=IF(A1>=50, "Pass", "Fail")Pass
41=AND(logical1, logical2)Check all conditions TRUE=AND(A1>10, B1<50)True
42=OR(logical1, logical2)Check any condition TRUE=OR(A1>10, B1>100)True
43=NOT(logical)Reverse logical result=NOT(A1>10)False
44=IFERROR(value, val_if_error)Catch calculation error=IFERROR(A1/B1, "Error")Error
45=COUNTIF(range, criteria)Count cells with 1 condition=COUNTIF(A1:A10, "Male")6
46=SUMIF(range, crit, [sum_range])Sum cells with 1 condition=SUMIF(A1:A10, ">100")500

5. Basic Information & Lookup Formulas

#FormulaDescriptionExampleResult
47=ISNUMBER(value)Check if cell is number=ISNUMBER(50)True
48=ISTEXT(value)Check if cell is text=ISTEXT("Sok")True
49=ISBLANK(value)Check if cell is empty=ISBLANK(A1)False
50=MATCH(val, array, [type])Find relative position in range=MATCH("Apple", A1:A5, 0)3

📥 Download PDF Cheatsheet Below

👉 Click link below to open and download PDF:

📥 Download 50 Excel Formulas PDF (Free)

📚 Useful Resources

Found this tutorial helpful? Share it with colleagues:
Share on X (Twitter)Share on LinkedInShare on FacebookShare on TelegramShare on Reddit
📚

Related Tutorials

Opens in new tab ↗
Advertisement