Can someone help me with this formula? I need to expand this somewhat:
{=MIN(IF(AK2:AK10="Yes",AJ2:AJ10))}
Here, I want to find the lowest value only if AK2:AK10 column = "Yes". But, I want to add 1 to the lowest value found or return zero if none of the conditions are met.
Thank you in advance.
{=MIN(IF(AK2:AK10="Yes",AJ2:AJ10))}
Here, I want to find the lowest value only if AK2:AK10 column = "Yes". But, I want to add 1 to the lowest value found or return zero if none of the conditions are met.
Thank you in advance.