A few weeks ago I posted a question about returning and displaying the minimum value between date ranges. There's a column of ascending dates, and next to that is a column indicating product availability. I wanted to return the minimum number available between when we had new product coming on. CAntosh provided me with an awesomely simple formula to return what I needed:
I'd like to add a complication to this that so that it only returns a number if it's greater than a value stored in a different cell. I'm able to do this somewhat messily if I use an IF statement:
So here's the primary question for this topic: Is it possible to do this without repeating the formula in the criteria and the result of the IF statement? I'm worried that it's going to add calculation overhead to a workbook that's already quite large.
I've attached an example file where this formula will be used. It's in range Y46:BI49
Bookmarks