## Happy Halloween! 👻

Let’s do something fun.

You are invited to leave your comments below. For what? For sharing with us any “weird” formula that you have ever seen in Excel. Real cases please. 😁

Wait… what do I mean “weird”?

Let’s define it in this way:

A weird formula is one that is written in a “strange” manner. It could be the uses of functions, or simply the way it is written.

Here’s my examples:

`=SUM(VLOOKUP(A1,D1:F10,2,false))`
`=SUM(A1+A2+A3)`
`=SUM(A1*A2)`

The above examples are real. I received a workbook where all formula are wrapped with SUM, for no particular reasons. All formula work perfectly fine without SUM. An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Formula and tagged . Bookmark the permalink.

### 1 Response to Have you encountered any weird formula in #Excel?

1. David N says:

=VLOOKUP(A1,Sheet2!A:A,1,FALSE)
This one is weird because VLOOKUP should never be used in the first place (use INDEX-MATCH instead). But I consider it especially weird because it’s an uninformative and somewhat circular formula. It’s a one-column search and return, so if the value we already have can be found, then we’ll get back the same thing we already had in the first place. A simple MATCH, wrapped inside ISNUMBER or ISNA if desired, is a more straightforward and informative way of asking the simple question of whether or not a match was found and can even tell us where it was found.

=IF(A1=B1,TRUE,FALSE)
Simply using =A1=B1 would give the same TRUE or FALSE answer.

Liked by 1 person

This site uses Akismet to reduce spam. Learn how your comment data is processed.