Learn How to Lookup Lowest Sunday Tide in Microsoft Excel
The main purpose of this formula is to find the lowest tide on a Sunday, given a set of data with many days of high and low tides. Here we will learn how to perform a lookup for the Lowest Sunday Tide in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the MIN and IF functions, you can able to find the lowest tide on a Sunday, given a set of data with many days of high and low tides.
So, with the help of this formula, you can able to perform a lookup for the Lowest Sunday Tide in the given data range in the workbook in Microsoft Excel.
General Formula to Lookup Lowest Sunday Tide
=MIN(IF(day=I5,IF(tide=”L”,pred)))
The Explanation to Lookup Lowest Sunday Tide
So we know that with the help of the given formula above you can able to find the lowest tide on a Sunday, given a set of data with many days of high and low tides.
Here we will learn how to perform the lookup for the Lowest Sunday Tide in the given data range in the workbook in Microsoft Excel. As we know that this example, we have to find a minimum value based on multiple criteria.
For this, we are using the MIN function together with two nested IF functions. It should be noted that we do not provide a “value if false” for either IF. That means if either logical test is FALSE, the outer IF will return FALSE.
So now you have learned how to perform the lookup for the Lowest Sunday Tide in the given data range in the workbook in Microsoft Excel.