Thread: Different range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
puiuluipui puiuluipui is offline
external usenet poster
 
Posts: 468
Default Different range

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!