Contents show
Halo, pembaca Sentigum sekalian! Pada kesempatan kali ini, Sentigum akan membahas tentang Daftar Fungsi Google Sheets.
Siapa di sini yang akrab atau sering bekerja menggunakan Google Sheets?
Sebenarnya, Google Sheets memiliki cara kerja yang sama dengan Microsoft Excel, hanya saja bisa dikerjakan secara online, jadi lebih fleksibel dalam penggunaannya.
Daftar Fungsi Google Sheets yang akan kami bagikan wajib kalian ketahui untuk mempermudah dan mempercepat pekerjaan Anda semua.
Oleh karena itu, simak artikel penjelasan Daftar Fungsi Google Sheets berikut ini sampai habis ya!
Daftar Fungsi Google Sheets
Fungsi atau Formula di Google Sheets dapat digunakan untuk memanipulasi data dengan lebih cepat.
Jika Anda termasuk para pekerja atau pelajar yang sering menggunakan Google Sheets atau Microsoft Excel, informasi Daftar Fungsi Google Sheets ini akan sangat membantu Anda semua.
Baca juga: 3 Cara Mengatur Spasi di Word
Berikut Daftar Fungsi Google Sheets yang harus Anda ketahui:
| NO | Nama | SINTAKSIS |
| 1 | ABS | ABS(value) |
| 2 | ACCRINT | ACCRINT(issue, first_payment, settlement, rate, redemption, frequency, [day_count_convention]) |
| 3 | ACCRINTM | ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention]) |
| 4 | ACOS | ACOS(value) |
| 5 | ACOSH | ACOSH(value) |
| 6 | ACOT | ACOT(value) |
| 7 | ACOTH | ACOTH(value) |
| 8 | ADD | ADD(value1, value2) |
| 9 | ADDRESS | ADDRESS(row, column, [absolute_relative_mode], [use_a1_notation], [sheet]) |
| 10 | AMORLINC | AMORLINC(cost, purchase_date, first_period_end, salvage, period, rate, [basis]) |
| 11 | AND | AND(logical_expression1, [logical_expression2, …]) |
| 12 | ARABIC | ARABIC(roman_numeral) |
| 13 | ARRAY_CONSTRAIN | ARRAY_CONSTRAIN(input_range, num_rows, num_cols) |
| 14 | ARRAYFORMULA | ARRAYFORMULA(array_formula) |
| 15 | ASC | ASC(text) |
| 16 | ASIN | ASIN(value) |
| 17 | ASINH | ASINH(value) |
| 18 | ATAN | ATAN(value) |
| 19 | ATAN2 | ATAN2(x, y) |
| 20 | ATANH | ATANH(value) |
| 21 | AVEDEV | AVEDEV(value1, [value2, …]) |
| 22 | AVERAGE | AVERAGE(value1, [value2, …]) |
| 23 | AVERAGE.WEIGHTED | AVERAGE.WEIGHTED(values, weights, [additional values], [additional weights]) |
| Daftar Fungsi Google Sheets | ||
| 24 | AVERAGEA | AVERAGEA(value1, [value2, …]) |
| 25 | AVERAGEIF | AVERAGEIF(criteria_range, criterion, [average_range]) |
| 26 | AVERAGEIFS | AVERAGEIFS(average_range, criteria_range1, criterion1, [criteria_range2, criterion2, …]) |
| 27 | BASE | BASE(value, base, [min_length]) |
| 28 | BETA.DIST | BETA.DIST(value, alpha, beta, cumulative, lower_bound, upper_bound) |
| 29 | BETA.INV | BETA.INV(probability, alpha, beta, lower_bound, upper_bound) |
| 30 | BETADIST | BETADIST(value, alpha, beta, lower_bound, upper_bound) |
| 31 | BETAINV | BETAINV(probability, alpha, beta, lower_bound, upper_bound) |
| 32 | BIN2DEC | BIN2DEC(signed_binary_number) |
| 33 | BIN2HEX | BIN2HEX(signed_binary_number, [significant_digits]) |
| 34 | BIN2OCT | BIN2OCT(signed_binary_number, [significant_digits]) |
| 35 | BINOM.DIST | BINOM.DIST(num_successes, num_trials, prob_success, cumulative) |
| 36 | BINOM.INV | BINOM.INV(num_trials, prob_success, target_prob) |
| 37 | BINOMDIST | BINOMDIST(num_successes, num_trials, prob_success, cumulative) |
| Daftar Fungsi Google Sheets | ||
| 38 | BITAND | BITAND(value1, value2) |
| 39 | BITLSHIFT | BITLSHIFT(value, shift_amount) |
| 40 | BITOR | BITOR(value1, value2) |
| 41 | BITRSHIFT | BITRSHIFT(value, shift_amount) |
| 42 | BITXOR | BITXOR(value1, value2) |
| 43 | CEILING | CEILING(value, [factor]) |
| 44 | CEILING.MATH | CEILING.MATH(number, [significance], [mode]) |
| 45 | CEILING.PRECISE | CEILING.PRECISE(number, [significance]) |
| 46 | CELL | CELL(info_type, reference) |
| 47 | CHAR | CHAR(table_number) |
| 48 | CHIDIST | CHIDIST(x, degrees_freedom) |
| 49 | CHIINV | CHIINV(probability, degrees_freedom) |
| 50 | CHISQ.DIST | CHISQ.DIST(x, degrees_freedom, cumulative) |
| 51 | CHISQ.DIST.RT | CHISQ.DIST.RT(x, degrees_freedom) |
| 52 | CHISQ.INV | CHISQ.INV(probability, degrees_freedom) |
| 53 | CHISQ.INV.RT | CHISQ.INV.RT(probability, degrees_freedom) |
| 54 | CHISQ.TEST | CHISQ.TEST(observed_range, expected_range) |
| 55 | CHITEST | CHITEST(observed_range, expected_range) |
| 56 | CHOOSE | CHOOSE(index, choice1, [choice2, …]) |
| 57 | CLEAN | CLEAN(text) |
| 58 | CODE | CODE(string) |
| 59 | COLUMN | COLUMN([cell_reference]) |
| Daftar Fungsi Google Sheets | ||
| 60 | COLUMNS | COLUMNS(range) |
| 61 | COMBIN | COMBIN(n, k) |
| 62 | COMBINA | COMBINA(n, k) |
| 63 | COMPLEX | COMPLEX(real_part, imaginary_part, [suffix]) |
| 64 | CONCAT | CONCAT(value1, value2) |
| 65 | CONCATENATE | CONCATENATE(string1, [string2, …]) |
| 66 | CONFIDENCE | CONFIDENCE(alpha, standard_deviation, pop_size) |
| 67 | CONFIDENCE.NORM | CONFIDENCE.NORM(alpha, standard_deviation, pop_size) |
| 68 | CONFIDENCE.T | CONFIDENCE.T(alpha, standard_deviation, size) |
| 69 | CONVERT | CONVERT(value, start_unit, end_unit) |
| 70 | CORREL | CORREL(data_y, data_x) |
| 71 | COS | COS(angle) |
| 72 | COSH | COSH(value) |
| 73 | COT | COT(angle) |
| 74 | COTH | COTH(value) |
| 75 | COUNT | COUNT(value1, [value2, …]) |
| 76 | COUNTA | COUNTA(value1, [value2, …]) |
| 77 | COUNTBLANK | COUNTBLANK(range) |
| 78 | COUNTIF | COUNTIF(range, criterion) |
| 79 | COUNTIFS | COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, …]) |
| 80 | COUNTUNIQUE | COUNTUNIQUE(value1, [value2, …]) |
| ||
| 81 | COUPDAYBS | COUPDAYBS(settlement, maturity, frequency, [day_count_convention]) |
| 82 | COUPDAYS | COUPDAYS(settlement, maturity, frequency, [day_count_convention]) |
| 83 | COUPDAYSNC | COUPDAYSNC(settlement, maturity, frequency, [day_count_convention]) |
| 84 | COUPNCD | COUPNCD(settlement, maturity, frequency, [day_count_convention]) |
| 85 | COUPNUM | COUPNUM(settlement, maturity, frequency, [day_count_convention]) |
| 86 | COUPPCD | COUPPCD(settlement, maturity, frequency, [day_count_convention]) |
| 87 | COVAR | COVAR(data_y, data_x) |
| 88 | COVARIANCE.P | COVARIANCE.P(data_y, data_x) |
| 89 | COVARIANCE.S | COVARIANCE.S(data_y, data_x) |
| 90 | CRITBINOM | CRITBINOM(num_trials, prob_success, target_prob) |
| 91 | CSC | CSC(angle) |
| 92 | CSCH | CSCH(value) |
| 93 | CUMIPMT | CUMIPMT(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning) |
| 94 | CUMPRINC | CUMPRINC(rate, number_of_periods, present_value, first_period, last_period, end_or_beginning) |
| Daftar Fungsi Google Sheets | ||
| 95 | DATE | DATE(year, month, day) |
| 96 | DATEDIF | DATEDIF(start_date, end_date, unit) |
| 97 | DATEVALUE | DATEVALUE(date_string) |
| 98 | DAVERAGE | DAVERAGE(database, field, criteria) |
| 99 | DAY | DAY(date) |
| 100 | DAYS | DAYS(end_date, start_date) |
| 101 | DAYS360 | DAYS360(start_date, end_date, [method]) |
| 102 | DB | DB(cost, salvage, life, period, [month]) |
| 103 | DCOUNT | DCOUNT(database, field, criteria) |
| 104 | DCOUNTA | DCOUNTA(database, field, criteria) |
| 105 | DDB | DDB(cost, salvage, life, period, [factor]) |
| 106 | DEC2BIN | DEC2BIN(decimal_number, [significant_digits]) |
| 107 | DEC2HEX | DEC2HEX(decimal_number, [significant_digits]) |
| 108 | DEC2OCT | DEC2OCT(decimal_number, [significant_digits]) |
| 109 | DECIMAL | DECIMAL(value, base) |
| 110 | DEGREES | DEGREES(angle) |
| 111 | DELTA | DELTA(number1, [number2]) |
| 112 | DETECTLANGUAGE | DETECTLANGUAGE(text_or_range) |
| 113 | DEVSQ | DEVSQ(value1, value2) |
| 114 | DGET | DGET(database, field, criteria) |
| 115 | DISC | DISC(settlement, maturity, price, redemption, [day_count_convention]) |
| 116 | DIVIDE | DIVIDE(dividend, divisor) |
| 117 | DMAX | DMAX(database, field, criteria) |
| 118 | DMIN | DMIN(database, field, criteria) |
| 119 | DOLLAR | DOLLAR(number, [number_of_places]) |
| 120 | DOLLARDE | DOLLARDE(fractional_price, unit) |
| Daftar Fungsi Google Sheets | ||
| 121 | DOLLARFR | DOLLARFR(decimal_price, unit) |
| 122 | DPRODUCT | DPRODUCT(database, field, criteria) |
| 123 | DSTDEV | DSTDEV(database, field, criteria) |
| 124 | DSTDEVP | DSTDEVP(database, field, criteria) |
| 125 | DSUM | DSUM(database, field, criteria) |
| 126 | DURATION | DURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) . |
| 127 | DVAR | DVAR(database, field, criteria) |
| 128 | DVARP | DVARP(database, field, criteria) |
| 129 | EDATE | EDATE(start_date, months) |
| 130 | EFFECT | EFFECT(nominal_rate, periods_per_year) |
| 131 | ENCODEURL | ENCODEURL(text) |
| 132 | EOMONTH | EOMONTH(start_date, months) |
| 133 | EQ | EQ(value1, value2) |
| 134 | ERF | ERF(lower_bound, [upper_bound]) |
| 135 | ERF.PRECISE | ERF.PRECISE(lower_bound, [upper_bound]) |
| 136 | ERFC | ERFC(z) |
| 137 | ERFC.PRECISE | ERFC.PRECISE(z) |
| 138 | ERROR.TYPE | ERROR.TYPE(reference) |
| 139 | EVEN | EVEN(value) |
| 140 | EXACT | EXACT(string1, string2) |
| 141 | EXP | EXP(exponent) |
| 142 | EXPON.DIST | EXPON.DIST(x, lambda, cumulative) |
| Daftar Fungsi Google Sheets | ||
| 143 | EXPONDIST | EXPONDIST(x, lambda, cumulative) |
| 144 | F.DIST | F.DIST(x, degrees_freedom1, degrees_freedom2, cumulative) |
| 145 | F.DIST.RT | F.DIST.RT(x, degrees_freedom1, degrees_freedom2) |
| 146 | F.INV | F.INV(probability, degrees_freedom1, degrees_freedom2) |
| 147 | F.INV.RT | F.INV.RT(probability, degrees_freedom1, degrees_freedom2) |
| 148 | F.TEST | F.TEST(range1, range2) |
| 149 | FACT | FACT(value) |
| 150 | FACTDOUBLE | FACTDOUBLE(value) |
| 151 | FDIST | FDIST(x, degrees_freedom1, degrees_freedom2) |
| 152 | FILTER | FILTER(range, condition1, [condition2]) |
| 153 | FIND | FIND(search_for, text_to_search, [starting_at]) |
| 154 | FINDB | FINDB(search_for, text_to_search, [starting_at]) |
| 155 | FINV | FINV(probability, degrees_freedom1, degrees_freedom2) |
| 156 | FISHER | FISHER(value) |
| 157 | FISHERINV | FISHERINV(value) |
| 158 | FIXED | FIXED(number, [number_of_places], [suppress_separator]) |
| 159 | FLOOR | FLOOR(value, [factor]) |
| Daftar Fungsi Google Sheets | ||
| 160 | FLOOR.MATH | FLOOR.MATH(number, [significance], [mode]) |
| 161 | FLOOR.PRECISE | FLOOR.PRECISE(number, [significance]) |
| 162 | FORECAST | FORECAST(x, data_y, data_x) |
| 163 | FORECAST.LINEAR | FORECAST.LINEAR(x, data_y, data_x) |
| 164 | FORMULATEXT | FORMULATEXT(cell) |
| 165 | FREQUENCY | FREQUENCY(data, classes) |
| 166 | FTEST | FTEST(range1, range2) |
| 167 | FV | FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning]) |
| 168 | FVSCHEDULE | FVSCHEDULE(principal, rate_schedule) |
| 169 | GAMMA | GAMMA(number) |
| 170 | GAMMA.DIST | GAMMA.DIST(x, alpha, beta, cumulative) |
| 171 | GAMMA.INV | GAMMA.INV(probability, alpha, beta) |
| 172 | GAMMADIST | GAMMADIST(x, alpha, beta, cumulative) |
| 173 | GAMMAINV | GAMMAINV(probability, alpha, beta) |
| 174 | GAMMALN | GAMMALN(value) |
| 175 | GAMMALN.PRECISE | GAMMALN.PRECISE(value) |
| 176 | GAUSS | GAUSS(z) |
| 177 | GCD | GCD(value1, value2) |
| 178 | GEOMEAN | GEOMEAN(value1, value2) |
| 179 | GESTEP | GESTEP(value, [step]) |
| 180 | GETPIVOTDATA | GETPIVOTDATA(value_name, any_pivot_table_cell, [original_column, …], [pivot_item, …] |
| 181 | GOOGLEFINANCE | GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval]) |
| 182 | GOOGLETRANSLATE | GOOGLETRANSLATE(text, [source_language], [target_language]) |
| 183 | GROWTH | GROWTH(known_data_y, [known_data_x], [new_data_x], [b]) |
| 184 | GT | GT(value1, value2) |
| 185 | GTE | GTE(value1, value2) |
| 186 | HARMEAN | HARMEAN(value1, value2) |
| 187 | HEX2BIN | HEX2BIN(signed_hexadecimal_number, [significant_digits]) |
| 188 | HEX2DEC | HEX2DEC(signed_hexadecimal_number) |
| 189 | HEX2OCT | HEX2OCT(signed_hexadecimal_number, significant_digits) |
| 190 | HLOOKUP | HLOOKUP(search_key, range, index, [is_sorted]) |
| Daftar Fungsi Google Sheets | ||
| 191 | HOUR | HOUR(time) |
| 192 | HYPERLINK | HYPERLINK(url, [link_label]) |
| 193 | HYPGEOM.DIST | HYPGEOM.DIST(num_successes, num_draws, successes_in_pop, pop_size) |
| 194 | HYPGEOMDIST | HYPGEOMDIST(num_successes, num_draws, successes_in_pop, pop_size) |
| 195 | IF | IF(logical_expression, value_if_true, value_if_false) |
| 196 | IFERROR | IFERROR(value, [value_if_error]) |
| 197 | IFNA | IFNA(value, value_if_na) |
| 198 | IFS | IFS(condition1, value1, [condition2, value2], …) |
| 199 | IMABS | IMABS(number) |
| 200 | IMAGE | IMAGE(url, [mode], [height], [width]) |
| 201 | IMAGINARY | IMAGINARY(complex_number) |
| 202 | IMARGUMENT | IMARGUMENT(number) |
| 203 | IMCONJUGATE | IMCONJUGATE(number) |
| 204 | IMCOS | IMCOS(number) |
| 205 | IMCOSH | IMCOSH(number) |
| 206 | IMCOT | IMCOT(number) |
| 207 | IMCOTH | IMCOTH(number) |
| 208 | IMCSC | IMCSC(number) |
| 209 | IMCSCH | IMCSCH(number) |
| 210 | IMDIV | IMDIV(dividend, divisor) |
| 211 | IMEXP | IMEXP(exponent) |
| 212 | IMLN | IMLN(complex_value) |
| 213 | IMLOG | IMLOG(value, base) |
| 214 | IMLOG10 | IMLOG10(value) |
| 215 | IMLOG2 | IMLOG2(value) |
| 216 | IMPORTDATA | IMPORTDATA(url) |
| 217 | IMPORTFEED | IMPORTFEED(url, [query], [headers], [num_items]) |
| 218 | IMPORTHTML | IMPORTHTML(url, query, index) |
| 219 | IMPORTRANGE | IMPORTRANGE(spreadsheet_url, range_string) |
| 220 | IMPORTXML | IMPORTXML(url, xpath_query) |
| 221 | IMPOWER | IMPOWER(complex_base, exponent) |
| 222 | IMPRODUCT | IMPRODUCT(factor1, [factor2, …]) |
| 223 | IMREAL | IMREAL(complex_number) |
| 224 | IMSEC | IMSEC(number) |
| 225 | IMSECH | IMSECH(number) |
| 226 | IMSIN | IMSIN (number) |
| 227 | IMSINH | IMSINH(number) |
| 228 | IMSQRT | IMSQRT(complex_number) |
| 229 | IMSUB | IMSUB(first_number, second_number) |
| 230 | IMSUM | IMSUM(value1, [value2, …]) |
| Daftar Fungsi Google Sheets | ||
| 231 | IMTAN | IMTAN(number) |
| 232 | IMTANH | IMTANH(number) |
| 233 | INDEX | INDEX(reference, [row], [column]) |
| 234 | INDIRECT | INDIRECT(cell_reference_as_string, [is_A1_notation]) |
| 235 | INT | INT(value) |
| 236 | INTERCEPT | INTERCEPT(data_y, data_x) |
| 237 | INTRATE | INTRATE(buy_date, sell_date, buy_price, sell_price, [day_count_convention]) |
| 238 | IPMT | IPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) |
| 239 | IRR | IRR(cashflow_amounts, [rate_guess]) |
| 240 | ISBLANK | ISBLANK(value) |
| 241 | ISDATE | ISDATE(value) |
| 242 | ISEMAIL | ISEMAIL(value) |
| 243 | ISERR | ISERR(value) |
| 244 | ISERROR | ISERROR(value) |
| 245 | ISEVEN | ISEVEN(value) |
| 246 | ISFORMULA | ISFORMULA(cell) |
| 247 | ISLOGICAL | ISLOGICAL(value) |
| 248 | ISNA | ISNA(value) |
| 249 | ISNONTEXT | ISNONTEXT(value) |
| 250 | ISNUMBER | ISNUMBER(value) |
| 251 | ISO.CEILING | ISO.CEILING(number, [significance]) |
| 252 | ISODD | ISODD(value) |
| 253 | ISOWEEKNUM | ISOWEEKNUM(date) |
| 254 | ISPMT | ISPMT(rate, period, number_of_periods, present_value) |
| Daftar Fungsi Google Sheets | ||
| 255 | ISREF | ISREF(value) |
| 256 | ISTEXT | ISTEXT(value) |
| 257 | ISURL | ISURL(value) |
| 258 | JOIN | JOIN(delimiter, value_or_array1, [value_or_array2, …]) |
| 259 | KURT | KURT(value1, value2) |
| 260 | LARGE | LARGE(data, n) |
| 261 | LCM | LCM(value1, value2) |
| 262 | LEFT | LEFT(string, [number_of_characters]) |
| 263 | LEFTB | LEFTB(string, num_of_bytes) |
| 264 | LEN | LEN(text) |
| 265 | LENB | LENB(string) |
| 266 | LINEST | LINEST(known_data_y, [known_data_x], [calculate_b], [verbose]) |
| 267 | LN | LN(value) |
| 268 | LOG | LOG(value, base) |
| 269 | LOG10 | LOG10(value) |
| 270 | LOGEST | LOGEST(known_data_y, [known_data_x], [b], [verbose]) |
| 271 | LOGINV | LOGINV(x, mean, standard_deviation) |
| 272 | LOGNORM.DIST | LOGNORM.DIST(x, mean, standard_deviation) |
| 273 | LOGNORM.INV | LOGNORM.INV(x, mean, standard_deviation) |
| 274 | LOGNORMDIST | LOGNORMDIST(x, mean, standard_deviation) |
| 275 | LOOKUP | LOOKUP(search_key, search_range|search_result_array, [result_range]) |
| 276 | LOWER | LOWER(text) |
| 277 | LT | LT(value1, value2) |
| 278 | LTE | LTE(value1, value2) |
| 279 | MATCH | MATCH(search_key, range, [search_type]) |
| 280 | MAX | MAX(value1, [value2, …]) |
| 281 | MAXA | MAXA(value1, value2) |
| 282 | MAXIFS | MAXIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …) |
| 283 | MDETERM | MDETERM(square_matrix) |
| 284 | MDURATION | MDURATION(settlement, maturity, rate, yield, frequency, [day_count_convention]) |
| 285 | MEDIAN | MEDIAN(value1, [value2, …]) |
| 286 | MID | MID(string, starting_at, extract_length) |
| 287 | MIDB | MIDB(string) |
| 288 | MIN | MIN(value1, [value2, …]) |
| 289 | MINA | MINA(value1, value2) |
| Daftar Fungsi Google Sheets | ||
| 290 | MINIFS | MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], …) |
| 291 | MINUS | MINUS(value1, value2) |
| 292 | MINUTE | MINUTE(time) |
| 293 | MINVERSE | MINVERSE(square_matrix) |
| 294 | MIRR | MIRR(cashflow_amounts, financing_rate, reinvestment_return_rate) |
| 295 | MMULT | MMULT(matrix1, matrix2) |
| 296 | MOD | MOD(dividend, divisor) |
| 297 | MODE | MODE(value1, [value2, …]) |
| 298 | MODE.MULT | MODE.MULT(value1, value2) |
| 299 | MODE.SNGL | MODE.SNGL(value1, [value2, …]) |
| 300 | MONTH | MONTH(date) |
| 301 | MROUND | MROUND(value, factor) |
| 302 | MULTINOMIAL | MULTINOMIAL(value1, value2) |
| 303 | MULTIPLY | MULTIPLY(factor1, factor2) |
| 304 | MUNIT | MUNIT(dimension) |
| 305 | N | N(value) |
| 306 | NA | NA() |
| 307 | NE | NE(value1, value2) |
| 308 | NEGBINOM.DIST | NEGBINOM.DIST(num_failures, num_successes, prob_success) |
| 309 | NEGBINOMDIST | NEGBINOMDIST(num_failures, num_successes, prob_success) |
| 310 | NETWORKDAYS | NETWORKDAYS(start_date, end_date, [holidays]) |
| 311 | NETWORKDAYS.INTL | NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) |
| 312 | NOMINAL | NOMINAL(effective_rate, periods_per_year) |
| 313 | NORM.DIST | NORM.DIST(x, mean, standard_deviation, cumulative) |
| 314 | NORM.INV | NORM.INV(x, mean, standard_deviation) |
| 315 | NORM.S.DIST | NORM.S.DIST(x) |
| 316 | NORM.S.INV | NORM.S.INV(x) |
| 317 | NORMDIST | NORMDIST(x, mean, standard_deviation, cumulative) |
| 318 | NORMINV | NORMINV(x, mean, standard_deviation) |
| 319 | NORMSDIST | NORMSDIST(x) |
| 320 | NORMSINV | NORMSINV(x) |
| 321 | NOT | NOT(logical_expression) |
| 322 | NOW | NOW() |
| 323 | NPER | NPER(rate, payment_amount, present_value, [future_value], [end_or_beginning]) |
| 324 | NPV | NPV(discount, cashflow1, [cashflow2, …]) |
| 325 | OCT2BIN | OCT2BIN(signed_octal_number, [significant_digits]) |
| Daftar Fungsi Google Sheets | ||
| 326 | OCT2DEC | OCT2DEC(signed_octal_number) |
| 327 | OCT2HEX | OCT2HEX(signed_octal_number, [significant_digits]) |
| 328 | ODD | ODD(value) |
| 329 | OFFSET | OFFSET(cell_reference, offset_rows, offset_columns, [height], [width]) |
| 330 | OR | OR(logical_expression1, [logical_expression2, …]) |
| 331 | PDURATION | PDURATION(rate, present_value, future_value) |
| 332 | PEARSON | PEARSON(data_y, data_x) |
| 333 | PERCENTILE | PERCENTILE(data, percentile) |
| 334 | PERCENTILE.EXC | PERCENTILE.EXC(data, percentile) |
| 335 | PERCENTILE.INC | PERCENTILE.INC(data, percentile) |
| 336 | PERCENTRANK | PERCENTRANK(data, value, [significant_digits]) |
| 337 | PERCENTRANK.EXC | PERCENTRANK.EXC(data, value, [significant_digits]) |
| 338 | PERCENTRANK.INC | PERCENTRANK.INC(data, value, [significant_digits]) |
| 339 | PERMUT | PERMUT(n, k) |
| 340 | PERMUTATIONA | PERMUTATIONA(number, number_chosen) |
| 341 | PHI | PHI(x) |
| 342 | PI | PI() |
| 343 | PMT | PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning]) |
| 344 | POISSON | POISSON(x, mean, cumulative) |
| Daftar Fungsi Google Sheets | ||
| 345 | POISSON.DIST | POISSON.DIST(x, mean, [cumulative]) |
| 346 | POW | POW(base, exponent) |
| 347 | POWER | POWER(base, exponent) |
| 348 | PPMT | PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning]) |
| 349 | PRICE | PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention]) |
| 350 | PRICEDISC | PRICEDISC(settlement, maturity, discount, redemption, [day_count_convention]) |
| 351 | PRICEMAT | PRICEMAT(settlement, maturity, issue, rate, yield, [day_count_convention]) |
| 352 | PROB | PROB(data, probabilities, low_limit, [high_limit]) |
| 353 | PRODUCT | PRODUCT(factor1, [factor2, …]) |
| 354 | PROPER | PROPER(text_to_capitalize) |
| 355 | PV | PV(rate, number_of_periods, payment_amount, [future_value], [end_or_beginning]) |
| 356 | QUARTILE | QUARTILE(data, quartile_number) |
| 357 | QUARTILE.EXC | QUARTILE.EXC(data, quartile_number) |
| 358 | QUARTILE.INC | QUARTILE.INC(data, quartile_number) |
| 359 | QUERY | QUERY(data, query, [headers]) |
| 360 | QUOTIENT | QUOTIENT(dividend, divisor) |
| 361 | RADIANS | RADIANS(angle) |
| 362 | RAND | RAND() |
| 363 | RANDARRAY | RANDARRAY(rows, columns) |
| 364 | RANDBETWEEN | RANDBETWEEN(low, high) |
| 365 | RANK | RANK(value, data, [is_ascending]) |
| 366 | RANK.AVG | RANK.AVG(value, data, [is_ascending]) |
| 367 | RANK.EQ | RANK.EQ(value, data, [is_ascending]) |
| 368 | RATE | RATE(number_of_periods, payment_per_period, present_value, [future_value], [end_or_beginning], [rate_guess]) |
| 369 | RECEIVED | RECEIVED(settlement, maturity, investment, discount, [day_count_convention]) |
| 370 | REGEXEXTRACT | REGEXEXTRACT(text, regular_expression) |
| 371 | REGEXMATCH | REGEXMATCH(text, regular_expression) |
| 372 | REGEXREPLACE | REGEXREPLACE(text, regular_expression, replacement) |
| 373 | REPLACE | REPLACE(text, position, length, new_text) |
| 374 | REPLACEB | REPLACEB(text, position, num_bytes, new_text) |
| 375 | REPT | REPT(text_to_repeat, number_of_repetitions) |
| Daftar Fungsi Google Sheets | ||
| 376 | RIGHT | RIGHT(string, [number_of_characters]) |
| 377 | RIGHTB | RIGHTB(string, num_of_bytes) |
| 378 | ROMAN | ROMAN(number, [rule_relaxation]) |
| 379 | ROUND | ROUND(value, [places]) |
| 380 | ROUNDDOWN | ROUNDDOWN(value, [places]) |
| 381 | ROUNDUP | ROUNDUP(value, [places]) |
| 382 | ROW | ROW([cell_reference]) |
| 383 | ROWS | ROWS(range) |
| 384 | RRI | RRI(number_of_periods, present_value, future_value) |
| 385 | RSQ | RSQ(data_y, data_x) |
| 386 | SEARCH | SEARCH(search_for, text_to_search, [starting_at]) |
| 387 | SEARCHB | SEARCHB(search_for, text_to_search, [starting_at]) |
| 388 | SEC | SEC(angle) |
| 389 | SECH | SECH(value) |
| 390 | SECOND | SECOND(time) |
| 391 | SEQUENCE | SEQUENCE(rows, columns, start, step) |
| 392 | SERIESSUM | SERIESSUM(x, n, m, a) |
| 393 | SIGN | SIGN(value) |
| 394 | SIN | SIN(angle) |
| 395 | SINH | SINH(value) |
| 396 | SKEW | SKEW(value1, value2) |
| 397 | SKEW.P | SKEW.P(value1, value2) |
| 398 | SLN | SLN(cost, salvage, life) |
| 399 | SLOPE | SLOPE(data_y, data_x) |
| 400 | SMALL | SMALL(data, n) |
| Daftar Fungsi Google Sheets | ||
| 401 | SORT | SORT(range, sort_column, is_ascending, [sort_column2], [is_ascending2]) |
| 402 | SORTN | SORTN(range, [n], [display_ties_mode], [sort_column1, is_ascending1], …) |
| 403 | SPARKLINE | SPARKLINE(data, [options]) |
| 404 | SPLIT | SPLIT(text, delimiter, [split_by_each], [remove_empty_text]) |
| 405 | SQRT | SQRT(value) |
| 406 | SQRTPI | SQRTPI(value) |
| 407 | STANDARDIZE | STANDARDIZE(value, mean, standard_deviation) |
| 408 | STDEV | STDEV(value1, [value2, …]) |
| 409 | STDEV.P | STDEV.P(value1, [value2, …]) |
| 410 | STDEV.S | STDEV.S(value1, [value2, …]) |
| 411 | STDEVA | STDEVA(value1, value2) |
| 412 | STDEVP | STDEVP(value1, value2) |
| 413 | STDEVPA | STDEVPA(value1, value2) |
| 414 | STEYX | STEYX(data_y, data_x) |
| 415 | SUBSTITUTE | SUBSTITUTE(text_to_search, search_for, replace_with, [occurrence_number]) |
| 416 | SUBTOTAL | SUBTOTAL(function_code, range1, [range2, …]) |
| 417 | SUM | SUM(value1, [value2, …]) |
| 418 | SUMIF | SUMIF(range, criterion, [sum_range]) |
| 419 | SUMIFS | SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, …]) |
| 420 | SUMPRODUCT | SUMPRODUCT(array1, [array2, …]) |
| 421 | SUMSQ | SUMSQ(value1, [value2, …]) |
| 422 | SUMX2MY2 | SUMX2MY2(array_x, array_y) |
| 423 | SUMX2PY2 | SUMX2PY2(array_x, array_y) |
| 424 | SUMXMY2 | SUMXMY2(array_x, array_y) |
| 425 | SWITCH | SWITCH(expression, case1, value1, [default or case2, value2], …) |
| 426 | SYD | SYD(cost, salvage, life, period) |
| 427 | T | T(value) |
| 428 | T.DIST | T.DIST(x, degrees_freedom, cumulative) |
| 429 | T.DIST.2T | T.DIST.2T(x, degrees_freedom) |
| 430 | T.DIST.RT | T.DIST.RT(x, degrees_freedom) |
| 431 | T.INV | T.INV(probability, degrees_freedom) |
| 432 | T.INV.2T | T.INV.2T(probability, degrees_freedom) |
| 433 | T.TEST | T.TEST(range1, range2, tails, type) |
| 434 | TAN | TAN(angle) |
| 435 | TANH | TANH(value) |
| 436 | TBILLEQ | TBILLEQ(settlement, maturity, discount) |
| Daftar Fungsi Google Sheets | ||
| 437 | TBILLPRICE | TBILLPRICE(settlement, maturity, discount) |
| 438 | TBILLYIELD | TBILLYIELD(settlement, maturity, price) |
| 439 | TDIST | TDIST(x, degrees_freedom, tails) |
| 440 | TEXT | TEXT(number, format) |
| 441 | TEXTJOIN | TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) |
| 442 | TIME | TIME(hour, minute, second) |
| 443 | TIMEVALUE | TIMEVALUE(time_string) |
| 444 | TINV | TINV(probability, degrees_freedom) |
| 445 | TO_DATE | TO_DATE(value) |
| 446 | TO_DOLLARS | TO_DOLLARS(value) |
| 447 | TO_PERCENT | TO_PERCENT(value) |
| 448 | TO_PURE_NUMBER | TO_PURE_NUMBER(value) |
| 449 | TO_TEXT | TO_TEXT(value) |
| 450 | TODAY | TODAY() |
| 451 | TRANSPOSE | TRANSPOSE(array_or_range) |
| 452 | TREND | TREND(known_data_y, [known_data_x], [new_data_x], [b]) |
| 453 | TRIM | TRIM(text) |
| 454 | TRIMMEAN | TRIMMEAN(data, exclude_proportion) |
| 455 | TRUNC | TRUNC(value, [places]) |
| 456 | TTEST | TTEST(range1, range2, tails, type) |
| 457 | TYPE | TYPE(value) |
| 458 | UMINUS | UMINUS(value) |
| 459 | UNARY_PERCENT | UNARY_PERCENT(percentage) |
| 460 | UNICHAR | UNICHAR(number) |
| 461 | UNICODE | UNICODE(text) |
| 462 | UNIQUE | UNIQUE(range) |
| 463 | UPLUS | UPLUS(value) |
| 464 | UPPER | UPPER(text) |
| 465 | VALUE | VALUE(text) |
| 466 | VAR | VAR(value1, [value2, …]) |
| 467 | VAR.P | VAR.P(value1, [value2, …]) |
| 468 | VAR.S | VAR.S(value1, [value2, …]) |
| Daftar Fungsi Google Sheets | ||
| 469 | VARA | VARA(value1, value2) |
| 470 | VARP | VARP(value1, value2) |
| 471 | VARPA | VARPA(value1, value2,…) |
| 472 | VDB | VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch]) |
| 473 | VLOOKUP | VLOOKUP(search_key, range, index, [is_sorted]) |
| 474 | WEEKDAY | WEEKDAY(date, [type]) |
| 475 | WEEKNUM | WEEKNUM(date, [type]) |
| 476 | WEIBULL | WEIBULL(x, shape, scale, cumulative) |
| 477 | WEIBULL.DIST | WEIBULL.DIST(x, shape, scale, cumulative) |
| 478 | WORKDAY | WORKDAY(start_date, num_days, [holidays]) |
| 479 | WORKDAY.INTL | WORKDAY.INTL(start_date, num_days, [weekend], [holidays]) |
| 480 | XIRR | XIRR(cashflow_amounts, cashflow_dates, [rate_guess]) |
| 481 | XNPV | XNPV(discount, cashflow_amounts, cashflow_dates) |
| 482 | XOR | XOR(logical_expression1, [logical_expression2, …]) |
| 483 | YEAR | YEAR(date) |
| 484 | YEARFRAC | YEARFRAC(start_date, end_date, [day_count_convention]) |
| 485 | YIELD | YIELD(settlement, maturity, rate, price, redemption, frequency, [day_count_convention]) |
| 486 | YIELDDISC | YIELDDISC(settlement, maturity, price, redemption, [day_count_convention]) |
| 487 | YIELDMAT | YIELDMAT(settlement, maturity, issue, rate, price, [day_count_convention]) |
| 488 | Z.TEST | Z.TEST(data, value, [standard_deviation]) |
| 489 | ZTEST | ZTEST(data, value, [standard_deviation]) |
| 490 | FALSE | FALSE() |
| 491 | TRUE | TRUE() |
Bagaimana? Apakah Anda sudah menemukan yang Anda cari di Daftar Fungsi Google Sheets di atas?
Semoga bisa membantu Anda mempercepat pekerjaan Anda semua ya.
Kesimpulan
Sekian penjelasana artikel Daftar Fungsi Google Sheets yang dapat Sentigum bagikan.
Sampai jumpa lagi pada pembahasan atikel bermanfaat selanjutnya ya!
Baca juga: Penggunaan Fungsi ABS di Google Sheets; Penggunaan Fungsi ADDRESS di Google Sheets; Cara Menggunakan dan Menyesuaikan Tema di Google Sheets.
Baca Juga:
- Penggunaan Fungsi ADDRESS di Google Sheets
- Daftar Fungsi Perbandingan di Google Sheets
- Penggunaan Fungsi ABS di Google Sheets
- Daftar Operator Perbandingan di Google Sheets
- Cara Menggunakan dan Menyesuaikan Tema di Google Sheets
- Bulldozer Rental Rates
- Crane Rental Prices Per Day & 6 Factors Affect Rental Cost
