Hello All,
Using Excel 2013, Windows 10
I have dates in row 1, values in 2 and 3 that formulas from another worksheet.
I'm trying to find the minimum value in rows 2 and 3 but only if it's less than today().
The formula I have is {=MIN(IF(A1:E1< TODAY(),A2:E2,0} The formula is showing the minimum value of zero for both rows when row 2 should have a minimum value of 3.
.............A........B......C..........D....................E.............. F(result) Should Be
....R1......9/23....9/24...9/25.....9/26...............9/27............................
....R2.......3........6.......4.....=sep26!A1....=sep26!A2..........0..............3
....R3........1.......0.......3.....=sep27!A1....=sep27!A2..........0..............0
Trying to get the formula to return the "should be" values, thanks.
Mike
Bookmarks