Excel formulas are powerful tools in Microsoft Excel that help simplify calculations, automate tasks, and analyze data efficiently. From basic arithmetic to complex data functions, they’re essential for professionals, students, and analysts alike. This page provides a clear guide to commonly used Excel formulas. It includes formulas for percentages, financial analysis, and everyday tasks. You’ll also find helpful resources on MS Excel formulas. Learn how to use them on your computer. Discover options to save Excel formulas to PDF. You can enhance your skills with this curated Excel formulas list. It is useful whether you’re in India or anywhere globally. It makes your workflow faster and more precise.
- Statistical Functions
AVERAGEAVERAGEAMEDIANMODE.SNGLMODE.MULTCOUNTCOUNTACOUNTBLANKCOUNTIFCOUNTIFSSTDEV.PSTDEV.SVAR.PVAR.SMAXMINPERCENTILE.INCPERCENTILE.EXCQUARTILE.INCQUARTILE.EXCRANK.EQRANK.AVGLARGESMALLPERCENTRANK.INCPERCENTRANK.EXCFREQUENCYTREND
- Logical Functions
IFIFERRORIFNAANDORNOTSWITCHIFSTRUEFALSEXOR
- Lookup & Reference Functions
VLOOKUPHLOOKUPXLOOKUPLOOKUPINDEXMATCHCHOOSEOFFSETROWCOLUMNROWSCOLUMNSADDRESSINDIRECTFORMULATEXTAREASHYPERLINKTRANSPOSE
- Text Functions
LEFTRIGHTMIDLENTEXTUPPERLOWERPROPERTRIMCONCATTEXTJOINFINDSEARCHREPLACESUBSTITUTEVALUEEXACTTCHARCODEUNICODEUNICHAR
- Date & Time Functions
TODAYNOWDATETIMEYEARMONTHDAYHOURMINUTESECONDWEEKDAYWEEKNUMEDATEEOMONTHNETWORKDAYSNETWORKDAYS.INTLWORKDAYWORKDAY.INTLDATEDIFDATEVALUETIMEVALUE
- Financial Functions
PMTIPMTPPMTFVPVNPERRATENPVIRRXIRRXNPVCUMIPMTCUMPRINCSLNSYDDDB
- Information Functions
ISBLANKISNUMBERISTEXTISERRORISERRISLOGICALISFORMULAISNATYPEERROR.TYPEINFOCELLNNA
- Array & Dynamic Array Functions
SEQUENCESORTSORTBYFILTERUNIQUETRANSPOSESINGLERANDARRAYTEXTSPLITTOCOLTOROWWRAPROWSWRAPCOLSVSTACKHSTACKCHOOSECOLSCHOOSEROWSDROPTAKEEXPAND
- Database Functions
DSUMDAVERAGEDCOUNTDCOUNTADGETDMAXDMINDPRODUCTDSTDEVDSTDEVPDVARDVARP
The Excel Varsity 