Sumifs Function
Are you tired of creating helper columns to be able to fetch data with sumif function? If you need to sum of a list of...
Tagged: condition
Vlookup Function
Vlookup function is one of the most important functions in excel for me. It helps you fetch a value from a list of values looking...
Conditional Formatting
Have you ever tried to change formatting of a cell or a range of cells based on a condition? If so, conditional formatting is the...
Choose Function
When you need to pick a value from a list of values depending on an index number, choose function is the one you need.
Nested functions
While excel has a lot of built-in formulas ready for your use, sometimes they may not fully fit the task at hand. In this kind...
Excel If Formula
Excel If function lets you make calculations or selections based on conditions. Excel if formula is likely one of the most used formulas in Excel. From...
