問題:返回最接近目標值的數(shù)字
問題:返回最接近目標值的數(shù)字
=MIN(IF(ABS($A$2:$A$23-C2)=MIN(ABS($A$2:$A$23-C2)),$A$2:$A$23,""))
數(shù)組3鍵
這個公式,相同最接近的話,就返回小的值
要大的值就用
=MAX(IF(ABS($A$2:$A$23-C2)=MIN(ABS($A$2:$A$23-C2)),$A$2:$A$23,""))
都要就用
=TEXTJOIN(",",1,IF(ABS($A$2:$A$23-C2)=MIN(ABS($A$2:$A$23-C2)),$A$2:$A$23,""))
UP:小賴同學愛學習
