如何判断A、B、C三列中的数值是否为等差数列？

楼主悟空师弟	问题：如下图：如何判断A、B、C三列中的数值升序排列后是否为等差数列？要求：不可使用VBA，不可定义名称，不可使用辅助列，D1内公式下拉完成。奖励：答案上交截止日前公式正确且字符数最短的楼层魅力值加10分，技能分加15分，其余不加分。说明：公式字符数为去掉=号后的字符数。答案公布日期：2011年2月10日后如何判断A、B、C三列中的数值是否为等差数列？.rar
2楼 rongjun	=IF(A1+B1+C1=3*MEDIAN(A1:C1),"是","否")
3楼 wjc2090742	=IF(A1+B1+C1=3*MEDIAN(A1:C1),"是","否") =IF(OR(A1:C1=(A1+B1+C1)/3),"是","否") 取巧，数据皆为整数时： =IF(MOD(STDEV(A1:C1),1),"否","是")
4楼 Zaezhong	=IF(OR(SUM(A1:C1)/A1:C1=3),"是","否") 去等号34
5楼 lrlxxqxa	=IF(SKEW(A1:C1),"否","是") 如何判断A、B、C三列中的数值是否为等差数列？(lr).rar
6楼 zzmxy	参与学习一下! 46个字符: =IF(SUM(LARGE(A1:C1,{1;2;3})*{1;-2;1}),"否","是")
7楼 foodorwater	=IF(LARGE(A1:C1,2)*2=SUM(LARGE(A1:C1,{1,3})),"是","否") 共52字符
8楼無心	先来一个很长的公式 =IF(OR(ABS(A1-B1)=ABS(B1-C1),ABS(A1-B1)=2ABS(B1-C1),2ABS(A1-B1)=ABS(B1-C1)),"是","否")
9楼無心	再短一点的 =IF((MAX(A1:C1)-MIN(A1:C1))/2+LARGE(A1:C1,2)=MAX(A1:C1),"是","否")
10楼無心	再短一点 =IF(LARGE(A1:C1,2)*2=MAX(A1:C1)+MIN(A1:C1),"是","否")
11楼無心	再短点 =IF(MOD(SUM(A1:C1),LARGE(A1:C1,2))=0,"是","否")
12楼無心	哈哈，一个比一个短 =IF(3*LARGE(A1:C1,2)=A1+B1+C1,"是","否") =IF(ROUND(SKEW(A1:C1),2),"否","是") 没办法，有浮点，只能加个round，要不然还能短点
13楼 amulee	=IF(SUM(A1:C1)/MEDIAN(A1:C1)=3,"是","否")
14楼 nothingwmm	=IF(ISNA(MATCH(ABS((A1-B1)/(A1-C1)),{1,0.5,2},)),"否","是") nothingwmm.rar
15楼涅磐86970	IF(SUM(SMALL(A1:C1,{1;2;3})*{1;-2;1}),"否","是") 46 如果可以设置单元格格式就好了- -
16楼 piny	目前最短34 ^^ 65 =IF((MAX(A1:C1)-MEDIAN(A1:C1))=(MEDIAN(A1:C1)-MIN(A1:C1)),"是","否") 62 =IF(MMULT({1,-1},MMULT(SMALL(A1:C1,{1,2;2,3}),{1;-1})),"否","是") 53 =IF(AVERAGE(SMALL(A1:C1,{1,3}))=MEDIAN(A1:C1),"是","否") 51 =IF(SUM(SMALL(A1:C1,{1,3}))/2=MEDIAN(A1:C1),"是","否") 48 =IF(STDEV(A1:C1)+MIN(A1:C1)=SUM(A1:C1)/3,"是","否") 41 =IF(OR(TRIMMEAN(A1:C1,1/3)=A1:C1),"是","否") 40 =IF(AVERAGE(A1:C1)=MEDIAN(A1:C1),"是","否") 38 =IF(SUM(A1:C1)/3=MEDIAN(A1:C1),"是","否") 37 =IF(SMALL(A1:C1,2)3=A1+B1+C1,"是","否") 36 =IF(MEDIAN(A1:C1)3=A1+B1+C1,"是","否") 36 =IF(OR(AVERAGE(A1:C1)=A1:C1),"是","否") 34 =IF(OR(SUM(A1:C1)/3=A1:C1),"是","否")
17楼 laowuwyx	笨办法，请老师指导。 =IF(MAX(A1:C1)+MIN(A1:C1)=2*MEDIAN(A1:C1),"是","否")
18楼 XIAO_JUN	=IF(SUM(MEDIAN(A1:C1)-A1:C1),"否","是") 数组字符：36
19楼 tntpai	=IF(SUM(A1:C1)/3=MEDIAN(A1:C1),"是","否")
20楼 donghan	=IF(MOD(MAX(ABS(A1-B1),ABS(A1-C1)),MIN(ABS(A1-B1),ABS(A1-C1))),"否","是")
21楼 guideming	=IF(OR(C1-B1=B1-A1,A1-C1=B1-A1,A1-C1=C1-B1),"是","否")
22楼 toby08	=IF(OR(SUM(A1:C1)/3=A1:C1),"是","否")
23楼 pzh130	=IF(MIN(A1:C1)+MAX(A1:C1)=SMALL(A1:C1,2)*2,"是","否")
24楼鬼狐	这个必须顶
25楼 w83365040371	=IF(AVERAGE(A1:C1)-MEDIAN(A1:C1),"否","是")