I am trying to devise an excel formula that is able to find the maximum value within a range of values that is less than a certain threshold. For example, if there was a range of values 1, 2, 3, 4 and 5, and the threshold value was set to 4, then the formula would return 3 as this is the maximum value below this threshold. If the threshold was set to 4.1 the formula would then return 4.
Many thanks in advance for your help.
Bookmarks