answersLogoWhite

0

Subjects>Electronics>Computers

Excel has more than 400 functions?

Updated: 10/3/2023
User Avatar

Wiki User

∙ 13y ago
Best Answer

333:

1 ABS

2 ACCRINT

3 ACCRINTM

4 ACOS

5 ACOSH

6 ADDRESS

7 AMORDEGRC

8 AMORLINC

9 AND

10 AREAS

11 ASC

12 ASIN

13 ASINH

14 ATAN

15 ATAN2

16 ATANH

17 AVEDEV

18 AVERAGE

19 AVERAGEA

20 BAHTTEXT

21 BESSELI

22 BESSELJ

23 BESSELK

24 BESSELY

25 BETADIST

26 BETAINV

27 BIN2DEC

28 BIN2HEX

29 BIN2OCT

30 BINOMDIST

31 CEILING

32 CELL

33 CHAR

34 CHIDIST

35 CHIINV

36 CHITEST

37 CHOOSE

38 CLEAN

39 CODE

40 COLUMN

41 COLUMNS

42 COMBIN

43 COMPLEX

44 CONCATENATE

45 CONFIDENCE

46 CONVERT

47 CORREL

48 COS

49 COSH

50 COUNT

51 COUNTA

52 COUNTBLANK

53 COUNTIF

54 COUPDAYBS

55 COUPDAYS

56 COUPDAYSNC

57 COUPNCD

58 COUPNUM

59 COUPPCD

60 COVAR

61 CRITBINOM

62 CUMIPMT

63 CUMPRINC

64 DATE

65 DATEVALUE

66 DAVERAGE

67 DAY

68 DAYS360

69 DB

70 DCOUNT

71 DCOUNTA

72 DDB

73 DEC2BIN

74 DEC2HEX

75 DEC2OCT

76 DEGREES

77 DELTA

78 DEVSQ

79 DGET

80 DISC

81 DMAX

82 DMIN

83 DOLLAR

84 DOLLARDE

85 DOLLARFR

86 DPRODUCT

87 DSTDEV

88 DSTDEVP

89 DSUM

90 DURATION

91 DVAR

92 DVARP

93 EDATE

94 EFFECT

95 EOMONTH

96 ERF

97 ERFC

98 ERROR.TYPE

99 EUROCONVERT

100 EVEN

101 EXACT

102 EXP

103 EXPONDIST

104 FACT

105 FACTDOUBLE

106 FALSE

107 FDIST

108 FIND, FINDB

109 FINV

110 FISHER

111 FISHERINV

112 FIXED

113 FLOOR

114 FORECAST

115 FREQUENCY

116 FTEST

117 FV

118 FVSCHEDULE

119 GAMMADIST

120 GAMMAINV

121 GAMMALN

122 GCD

123 GEOMEAN

124 GESTEP

125 GETPIVOTDATA

126 GROWTH

127 HARMEAN

128 HEX2BIN

129 HEX2DEC

130 HEX2OCT

131 HLOOKUP

132 HOUR

133 HYPERLINK

134 HYPGEOMDIST

135 IF

136 IMABS

137 IMAGINARY

138 IMARGUMENT

139 IMCONJUGATE

140 IMCOS

141 IMDIV

142 IMEXP

143 IMLN

144 IMLOG10

145 IMLOG2

146 IMPOWER

147 IMPRODUCT

148 IMREAL

149 IMSIN

150 IMSQRT

151 IMSUB

152 IMSUM

153 INDEX

154 INDIRECT

155 INFO

156 INT

157 INTERCEPT

158 INTRATE

159 IPMT

160 IRR

161 ISBLANK

162 ISERR

163 ISERROR

164 ISEVEN

165 ISLOGICAL

166 ISNA

167 ISNONTEXT

168 ISNUMBER

169 ISODD

170 ISPMT

171 ISREF

172 ISTEXT

173 JIS

174 KURT

175 LARGE

176 LCM

177 LEFT, LEFTB

178 LEN, LENB

179 LINEST

180 LN

181 LOG

182 LOG10

183 LOGEST

184 LOGINV

185 LOGNORMDIST

186 LOOKUP

187 LOWER

188 MATCH

189 MAX

190 MAXA

191 MDETERM

192 MDURATION

193 MEDIAN

194 MID, MIDB

195 MIN

196 MINA

197 MINUTE

198 MINVERSE

199 MIRR

200 MMULT

201 MOD

202 MODE

203 MONTH

204 MROUND

205 MULTINOMIAL

206 N

207 NA

208 NEGBINOMDIST

209 NETWORKDAYS

210 NOMINAL

211 NORMDIST

212 NORMINV

213 NORMSDIST

214 NORMSINV

215 NOT

216 NOW

217 NPER

218 NPV

219 OCT2BIN

220 OCT2DEC

221 OCT2HEX

222 ODD

223 ODDFPRICE

224 ODDFYIELD

225 ODDLPRICE

226 ODDLYIELD

227 OFFSET

228 OR

229 PEARSON

230 PERCENTILE

231 PERCENTRANK

232 PERMUT

233 PHONETIC

234 PI

235 PMT

236 POISSON

237 POWER

238 PPMT

239 PRICE

240 PRICEDISC

241 PRICEMAT

242 PROB

243 PRODUCT

244 PROPER

245 PV

246 QUARTILE

247 QUOTIENT

248 RADIANS

249 RAND

250 RANDBETWEEN

251 RANK

252 RATE

253 RECEIVED

254 REPLACE, REPLACEB

255 REPT

256 RIGHT, RIGHTB

257 ROMAN

258 ROUND

259 ROUNDDOWN

260 ROUNDUP

261 ROW

262 ROWS

263 RSQ

264 RTD

265 SEARCH, SEARCHB

266 SECOND

267 SERIESSUM

268 SIGN

269 SIN

270 SINH

271 SKEW

272 SLN

273 SLOPE

274 SMALL

275 SQL.REQUEST

276 SQRT

277 SQRTPI

278 STANDARDIZE

279 STDEV

280 STDEVA

281 STDEVP

282 STDEVPA

283 STEYX

284 SUBSTITUTE

285 SUBTOTAL

286 SUM

287 SUMIF

288 SUMPRODUCT

289 SUMSQ

290 SUMX2MY2

291 SUMX2PY2

292 SUMXMY2

293 SYD

294 T

295 TAN

296 TANH

297 TBILLEQ

298 TBILLPRICE

299 TBILLYIELD

300 TDIST

301 TEXT

302 TIME

303 TIMEVALUE

304 TINV

305 TODAY

306 TRANSPOSE

307 TREND

308 TRIM

309 TRIMMEAN

310 TRUE

311 TRUNC

312 TTEST

313 TYPE

314 UPPER

315 VALUE

316 VAR

317 VARA

318 VARP

319 VARPA

320 VDB

321 VLOOKUP

322 WEEKDAY

323 WEEKNUM

324 WEIBULL

325 WORKDAY

326 XIRR

327 XNPV

328 YEAR

329 YEARFRAC

330 YIELD

331 YIELDDISC

332 YIELDMAT

333 ZTEST

User Avatar

Wiki User

∙ 7y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

∙ 9y ago

There are 341 built-in functions in Excel. However, using these, the amount of things you can do is unlimited. Excel also has many special facilities to do things, like the Solver or Goal Seek.

This answer is:
User Avatar
User Avatar

Wiki User

∙ 14y ago

Yes.

Reference- Microsoft Office 2007 (Shelly Cashman Vermaat) Page EX104

This answer is:
User Avatar
User Avatar

Wiki User

∙ 8y ago

There's about 400 functions in Excel 2010, with less in earlier versions.

This answer is:
User Avatar
User Avatar

Wiki User

∙ 12y ago

NO! sorry i pretty sure it has 333 functions!

This answer is:
User Avatar
User Avatar

Wiki User

∙ 8y ago

Yes, Excel now has well over 400 in-built functions.

This answer is:
User Avatar
User Avatar

Wiki User

∙ 13y ago

This is a statement, not a question. Ask again using words that make it clear what you want to know.

This answer is:
User Avatar
User Avatar

Wiki User

∙ 12y ago

true

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Excel has more than 400 functions?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What are the 20 function in excel?

It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.It has a lot more than 25 functions. Excel has over 400 built-in functions. In general terms of the functionality of Excel you would also say there are a lot more than 25, as there are a huge amount of things you can do with Excel.

Does Excel 2010 have more than 3000 functions?

No, it has nowhere near 3000 functions. It has about 400 functions.

Which park in EL Salvador hold more than 400 trees?

the park that had more than 400 trees

What is 400 more than 230?

630

Is 1865010858 more or less than 400 million?

Yes. 1,865,010,858 is more than 400,000,000

What is 400 percent more than 200?

It is 204.

Is 400 grams more than 4 kilogram?

No.

Is 400 pints more than 100 gallons?

No.

What food item does France have more than 365 of?

France has more than 365 varieties of cheese (actually more than 400)

Is 4 cenitimeters less or more than 400 decimeters?

Less, 400 decimeters = 4000 centimeters

What religion was founded before ad 400?

Islam was founded in more than 200 years after AD 400.

Is 400 mm more than 40 cm?

400 mm = 40 cm

Resources

Leaderboard All Tags Unanswered

Top Categories

Algebra Chemistry Biology World History English Language Arts Psychology Computer Science Economics

Product

Community Guidelines Honor Code Flashcard Maker Study Guides Math Solver FAQ

Company

About Us Contact Us Terms of Use Privacy Policy Disclaimer Cookie Policy IP Issues
Answers Logo
Copyright ©2024 Infospace Holdings LLC, A System1 Company. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.