Whenever you need to cross reference two lists, the MATCH function is a pretty useful function to have in your arsenal. Just as the name implies, it checks whether an item in one list is present in …
IFERROR – Make pesky formula errors go away
I’m not sure why, but less people use the IFERROR function than I would expect. If you’re someone that likes to see neatly organized and clean spreadsheets (like me) then this section is for you. I …
Continue Reading about IFERROR – Make pesky formula errors go away →
IF Function in Microsoft Excel: With Examples
The IF function in Microsoft Excel is one of the most important, versatile, and powerful tools excel has to offer and a must have for anyone becoming an excel pro. This function allows you to build …
Continue Reading about IF Function in Microsoft Excel: With Examples →