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

How to Perform State Management using the Composition API in Vue.js

Create a Shopping List with Akita and Angular

Insertion Sort

Building a Location-Based App with Appwrite

Pins on a map

What is ReactJS?

Writing WordPress REST API Endpoints Like Laravel Code

Controlling the Full-Screen Mode

Netflix on Fullscreen Mode

Leetcode 1447: Simplified Fractions

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

Editing dynamic arrays in Excel (part 1)

Google Sheets vs Excel — Who Comes Out on Top?

Google Sheets vs Excel - Who Comes Out on Top?

APPLYING INDEX AND MATCH FUNCTIONS IN MICROSOFT EXCEL

Tools I love