随机生 度與分位之間 (9735)


A1:E10=SUBSTITUTE(TEXT(RANDBETWEEN(21,59)*2+8900,"00°±00'"),"±0","±")


另解=SUBSTITUTE(TEXT(EVEN(RANDBETWEEN(8942,9018)),"00°±00'"),"±0","±")


另解 (只到60')=TEXT(RANDBETWEEN(2691,2709)%/432,"[m]°s′")


留言