=IFERROR(IF(C11/C12=C12/C13,IF(C11/C12>1,C11/C12,C12/C11),IF(C11/C13=C13/C12,IF(C11/C13>1,C11/C13,C13/C11),"")),"")
可以实现判断是否等比数列.但只能是D14对应C14-C16.
=IFERROR(IF(C11/C12=C12/C13,IF(C11/C12>1,C11/C12,C12/C11),IF(C11/C13=C13/C12,IF(C11/C13>1,C11/C13,C13/C11),"")),"")
可以实现判断是否等比数列.但只能是D14对应C14-C16.