visualizer
/
vendor
/
phpoffice
/
phpspreadsheet
/
src
/
PhpSpreadsheet
/
Calculation
/
functionlist.txt
functionlist.txt in Visualizer – Tables & Charts Manager with Built-in AI Generator 3.7.1, at vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/functionlist.txt
| 1 | ABS |
| 2 | ACCRINT |
| 3 | ACCRINTM |
| 4 | ACOS |
| 5 | ACOSH |
| 6 | ACOT |
| 7 | ACOTH |
| 8 | ADDRESS |
| 9 | AMORDEGRC |
| 10 | AMORLINC |
| 11 | AND |
| 12 | AREAS |
| 13 | ASC |
| 14 | ASIN |
| 15 | ASINH |
| 16 | ATAN |
| 17 | ATAN2 |
| 18 | ATANH |
| 19 | AVEDEV |
| 20 | AVERAGE |
| 21 | AVERAGEA |
| 22 | AVERAGEIF |
| 23 | AVERAGEIFS |
| 24 | BAHTTEXT |
| 25 | BESSELI |
| 26 | BESSELJ |
| 27 | BESSELK |
| 28 | BESSELY |
| 29 | BETADIST |
| 30 | BETAINV |
| 31 | BIN2DEC |
| 32 | BIN2HEX |
| 33 | BIN2OCT |
| 34 | BINOMDIST |
| 35 | BITAND |
| 36 | BITLSHIFT |
| 37 | BITOR |
| 38 | BITRSHIFT |
| 39 | BITXOR |
| 40 | CEILING |
| 41 | CELL |
| 42 | CHAR |
| 43 | CHIDIST |
| 44 | CHIINV |
| 45 | CHITEST |
| 46 | CHOOSE |
| 47 | CLEAN |
| 48 | CODE |
| 49 | COLUMN |
| 50 | COLUMNS |
| 51 | COMBIN |
| 52 | COMPLEX |
| 53 | CONCAT |
| 54 | CONCATENATE |
| 55 | CONFIDENCE |
| 56 | CONVERT |
| 57 | CORREL |
| 58 | COS |
| 59 | COSH |
| 60 | COT |
| 61 | COTH |
| 62 | COUNT |
| 63 | COUNTA |
| 64 | COUNTBLANK |
| 65 | COUNTIF |
| 66 | COUNTIFS |
| 67 | COUPDAYBS |
| 68 | COUPDAYBS |
| 69 | COUPDAYSNC |
| 70 | COUPNCD |
| 71 | COUPNUM |
| 72 | COUPPCD |
| 73 | COVAR |
| 74 | CRITBINOM |
| 75 | CSC |
| 76 | CSCH |
| 77 | CUBEKPIMEMBER |
| 78 | CUBEMEMBER |
| 79 | CUBEMEMBERPROPERTY |
| 80 | CUBERANKEDMEMBER |
| 81 | CUBESET |
| 82 | CUBESETCOUNT |
| 83 | CUBEVALUE |
| 84 | CUMIPMT |
| 85 | CUMPRINC |
| 86 | DATE |
| 87 | DATEDIF |
| 88 | DATEVALUE |
| 89 | DAVERAGE |
| 90 | DAY |
| 91 | DAYS |
| 92 | DAYS360 |
| 93 | DB |
| 94 | DCOUNT |
| 95 | DCOUNTA |
| 96 | DDB |
| 97 | DEC2BIN |
| 98 | DEC2HEX |
| 99 | DEC2OCT |
| 100 | DEGREES |
| 101 | DELTA |
| 102 | DEVSQ |
| 103 | DGET |
| 104 | DISC |
| 105 | DMAX |
| 106 | DMIN |
| 107 | DOLLAR |
| 108 | DOLLARDE |
| 109 | DOLLARFR |
| 110 | DPRODUCT |
| 111 | DSTDEV |
| 112 | DSTDEVP |
| 113 | DSUM |
| 114 | DURATION |
| 115 | DVAR |
| 116 | DVARP |
| 117 | EDATE |
| 118 | EFFECT |
| 119 | EOMONTH |
| 120 | ERF |
| 121 | ERF.PRECISE |
| 122 | ERFC |
| 123 | ERFC.PRECISE |
| 124 | ERROR.TYPE |
| 125 | EVEN |
| 126 | EXACT |
| 127 | EXP |
| 128 | EXPONDIST |
| 129 | FACT |
| 130 | FACTDOUBLE |
| 131 | FALSE |
| 132 | FDIST |
| 133 | FIND |
| 134 | FINDB |
| 135 | FINV |
| 136 | FISHER |
| 137 | FISHERINV |
| 138 | FIXED |
| 139 | FLOOR |
| 140 | FORECAST |
| 141 | FREQUENCY |
| 142 | FTEST |
| 143 | FV |
| 144 | FVSCHEDULE |
| 145 | GAMAMDIST |
| 146 | GAMMAINV |
| 147 | GAMMALN |
| 148 | GCD |
| 149 | GEOMEAN |
| 150 | GESTEP |
| 151 | GETPIVOTDATA |
| 152 | GROWTH |
| 153 | HARMEAN |
| 154 | HEX2BIN |
| 155 | HEX2OCT |
| 156 | HLOOKUP |
| 157 | HOUR |
| 158 | HYPERLINK |
| 159 | HYPGEOMDIST |
| 160 | IF |
| 161 | IFERROR |
| 162 | IMABS |
| 163 | IMAGINARY |
| 164 | IMARGUMENT |
| 165 | IMCONJUGATE |
| 166 | IMCOS |
| 167 | IMCOSH |
| 168 | IMCOT |
| 169 | IMCSC |
| 170 | IMCSCH |
| 171 | IMEXP |
| 172 | IMLN |
| 173 | IMLOG10 |
| 174 | IMLOG2 |
| 175 | IMPOWER |
| 176 | IMPRODUCT |
| 177 | IMREAL |
| 178 | IMSEC |
| 179 | IMSECH |
| 180 | IMSIN |
| 181 | IMSINH |
| 182 | IMSQRT |
| 183 | IMSUB |
| 184 | IMSUM |
| 185 | IMTAN |
| 186 | INDEX |
| 187 | INDIRECT |
| 188 | INFO |
| 189 | INT |
| 190 | INTERCEPT |
| 191 | INTRATE |
| 192 | IPMT |
| 193 | IRR |
| 194 | ISBLANK |
| 195 | ISERR |
| 196 | ISERROR |
| 197 | ISEVEN |
| 198 | ISLOGICAL |
| 199 | ISNA |
| 200 | ISNONTEXT |
| 201 | ISNUMBER |
| 202 | ISODD |
| 203 | ISOWEEKNUM |
| 204 | ISPMT |
| 205 | ISREF |
| 206 | ISTEXT |
| 207 | JIS |
| 208 | KURT |
| 209 | LARGE |
| 210 | LCM |
| 211 | LEFT |
| 212 | LEFTB |
| 213 | LEN |
| 214 | LENB |
| 215 | LINEST |
| 216 | LN |
| 217 | LOG |
| 218 | LOG10 |
| 219 | LOGEST |
| 220 | LOGINV |
| 221 | LOGNORMDIST |
| 222 | LOOKUP |
| 223 | LOWER |
| 224 | MATCH |
| 225 | MAX |
| 226 | MAXA |
| 227 | MDETERM |
| 228 | MDURATION |
| 229 | MEDIAN |
| 230 | MID |
| 231 | MIDB |
| 232 | MIN |
| 233 | MINA |
| 234 | MINUTE |
| 235 | MINVERSE |
| 236 | MIRR |
| 237 | MMULT |
| 238 | MOD |
| 239 | MODE |
| 240 | MONTH |
| 241 | MROUND |
| 242 | MULTINOMIAL |
| 243 | N |
| 244 | NA |
| 245 | NEGBINOMDIST |
| 246 | NETWORKDAYS |
| 247 | NOMINAL |
| 248 | NORMDIST |
| 249 | NORMINV |
| 250 | NORMSDIST |
| 251 | NORMSINV |
| 252 | NOT |
| 253 | NOW |
| 254 | NPER |
| 255 | NPV |
| 256 | NUMBERVALUE |
| 257 | OCT2BIN |
| 258 | OCT2DEC |
| 259 | OCT2HEX |
| 260 | ODD |
| 261 | ODDFPRICE |
| 262 | ODDFYIELD |
| 263 | ODDLPRICE |
| 264 | ODDLYIELD |
| 265 | OFFSET |
| 266 | OR |
| 267 | PDURATION |
| 268 | PEARSON |
| 269 | PERCENTILE |
| 270 | PERCENTRANK |
| 271 | PERMUT |
| 272 | PHONETIC |
| 273 | PI |
| 274 | PMT |
| 275 | POISSON |
| 276 | POWER |
| 277 | PPMT |
| 278 | PRICE |
| 279 | PRICEDISC |
| 280 | PRICEMAT |
| 281 | PROB |
| 282 | PRODUCT |
| 283 | PROPER |
| 284 | PV |
| 285 | QUARTILE |
| 286 | QUOTIENT |
| 287 | RADIANS |
| 288 | RAND |
| 289 | RANDBETWEEN |
| 290 | RANK |
| 291 | RATE |
| 292 | RECEIVED |
| 293 | REPLACE |
| 294 | REPLACEB |
| 295 | REPT |
| 296 | RIGHT |
| 297 | RIGHTB |
| 298 | ROMAN |
| 299 | ROUND |
| 300 | ROUNDDOWN |
| 301 | ROUNDUP |
| 302 | ROW |
| 303 | ROWS |
| 304 | RRI |
| 305 | RSQ |
| 306 | RTD |
| 307 | SEARCH |
| 308 | SEARCHB |
| 309 | SEC |
| 310 | SECH |
| 311 | SECOND |
| 312 | SERIESSUM |
| 313 | SIGN |
| 314 | SIN |
| 315 | SINH |
| 316 | SKEW |
| 317 | SLN |
| 318 | SLOPE |
| 319 | SMALL |
| 320 | SQRT |
| 321 | SQRTPI |
| 322 | STANDARDIZE |
| 323 | STDEV |
| 324 | STDEV.A |
| 325 | STDEV.P |
| 326 | STDEVA |
| 327 | STDEVP |
| 328 | STDEVPA |
| 329 | STEYX |
| 330 | SUBSTITUTE |
| 331 | SUBTOTAL |
| 332 | SUM |
| 333 | SUMIF |
| 334 | SUMIFS |
| 335 | SUMPRODUCT |
| 336 | SUMSQ |
| 337 | SUMX2MY2 |
| 338 | SUMX2PY2 |
| 339 | SUMXMY2 |
| 340 | SWITCH |
| 341 | SYD |
| 342 | T |
| 343 | TAN |
| 344 | TANH |
| 345 | TBILLEQ |
| 346 | TBILLPRICE |
| 347 | TBILLYIELD |
| 348 | TDIST |
| 349 | TEXT |
| 350 | TEXTJOIN |
| 351 | TIME |
| 352 | TIMEVALUE |
| 353 | TINV |
| 354 | TODAY |
| 355 | TRANSPOSE |
| 356 | TREND |
| 357 | TRIM |
| 358 | TRIMMEAN |
| 359 | TRUE |
| 360 | TRUNC |
| 361 | TTEST |
| 362 | TYPE |
| 363 | UNICHAR |
| 364 | UNIORD |
| 365 | UPPER |
| 366 | USDOLLAR |
| 367 | VALUE |
| 368 | VAR |
| 369 | VARA |
| 370 | VARP |
| 371 | VARPA |
| 372 | VDB |
| 373 | VLOOKUP |
| 374 | WEEKDAY |
| 375 | WEEKNUM |
| 376 | WEIBULL |
| 377 | WORKDAY |
| 378 | XIRR |
| 379 | XNPV |
| 380 | XOR |
| 381 | YEAR |
| 382 | YEARFRAC |
| 383 | YIELD |
| 384 | YIELDDISC |
| 385 | YIELDMAT |
| 386 | ZTEST |
| 387 |