Hi,
=if(E58=10000,{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59},if(E58=15000,{=MIN(IF(T 5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59})

if this helps please click yes, thanks

"puiuluipui" wrote:

Hi, i need to modify a little bit this formula :
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}. If i enter a
number in cell "E58" the formula to look in column "S" and if i enter another
number to look in column "T".

If in "E58" is "10.000" than the formula to be identical and to look in
"S5:S24".
{=MIN(IF(S5:S24$E$59,(S5:S24)-$E$59,MAX(S5:S24)))+$E$59}

If in "E58" is "15.000" than the formula to look in "T5:T24".
{=MIN(IF(T5:T24$E$59,(T5:T24)-$E$59,MAX(T5:T24)))+$E$59}

Can this be done?
Thanks!