How to create a time calculator in Excel

How to create a time calculator in Excel

When you need to calculate the difference between a time present day and the next day, calculations can get messed up and you will see lots of # characters. This article shows how to create a time calculator in Excel that can calculate shift time after midnight using...
How to get last match

How to get last match

This article shows how to get last match by using MAX, MIN, IF and ROW functions. Excel’s array formula ability to evaluate formula for each cells in an array is key factor in this case.Syntax{ =MAX( IF( data = search value, ROW( data ) – MIN( ROW( data )...
How to create conditional Excel drop down lists

How to create conditional Excel drop down lists

It’s often a good idea to use drop down lists or combo boxes to limit user errors make the data more standardized. However, sometimes we want our drop downs to populate under some conditions. Here, you can find out how to create conditional Excel drop down using Data...
How to use multiple IF functions

How to use multiple IF functions

The IF function is great for creating a logic statement. But IF is an either/or argument, what if you need more alternatives? Combining several IF statements in a nested structure can help overcome this. Syntax =IF(first logical test, do something if first test is...