Kumpulan FUNGSI RUMUS FORMULA Microsoft Excel

A. FUNGSI LOGIKA

1. AND
2. SINGLE IF
3. MULTI IF
4. NOT
5. OR

B. FUNGSI INFORMASI

1. CELL
2. COUNTBLANK
3. ERROR.TYPE
4. INFO
5. ISBLANK
6. ISERR
7. ISERROR
8. ISNA
9. ISNONTEXT
10. ISNUMBER
11. ISREF
12. ISTEXT
13. N
14. TYPE

C. FUNGSI TEXT

1. CLEAN
2. CODE
3. CONCATENATE
4. DOLLAR
5. EXACT
6. FIND
7. FIXED
8. LEFT
9. RIGHT
10. LEN
11. LOWER
12. UPPER
13. PROPER
14. REPLACE
15. REPT
16. SEARCH
17. SUBTITUTE
18. T
19. TEXT
20. VALUE
21. TRIM

DOWNLOAD DISINI