Cheatsheet — Excel

This is my personal collection of cheatsheet for Excel.

Indian Number Format

[>=10000000]##\,##\,##\,##0;[>=100000] ##\,##\,##0;##,##0.00

Current Day, Month & Year

=MONTH(TODAY())    // Current month
=YEAR(TODAY()) // Current year
=DAY(TODAY()) // Current day of month. (Select type as number)

DATEIF

  • Calculate difference between dates.
=DATEDIF(M4,TODAY(), "M")

IF ELSE

=IF(TRUE,4,5)

Last Value of Column

=LOOKUP(2,1/(B:B<>""),B:B)

IFERROR

  • If formula can give error, this will help to handle that error.
=IFERROR (value, value_if_error)

--

--

--

Loves coding and enjoys learning new technologies. Website: https://.yuvrajpatil.com

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Making An Animated JavaScript and WebGL Gradient

GSoC 2020 : Second Evaluation

How to create Vuex Store with vuex-module-decorators and Vuexfire

Scope and Closure in Javascript

a meme about closure — a large man labeled “inner function” carrying a massive backpack labeled “secret variables from outer function”

How I Got Into #Node: Jennifer Bland

React App with WebSocket implemented inside WebWorker

Javascript Object Constructors.

Influence of Fast Refresh Feature in React Native 0.61 on the Developer Community!

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Yuvraj Patil

Yuvraj Patil

Loves coding and enjoys learning new technologies. Website: https://.yuvrajpatil.com

More from Medium

How to use the Offset Function for Scenario Analysis

How to Split Data with Delimiters into New Rows

Excel Tables Explained — 14 Amazing Best Practices For Your Excel Table

Tired of Formatting Pivot Tables in Excel? Build an Add-in in 5 Minutes