Embedded Files
- convert real number to radical #BIF #GAS
=ArrayFormula(let(r,A1,n,20,JOIN("√",VLOOKUP(0,{mod(r,(n+1-SEQUENCE(n))^2),(n+1-SEQUENCE(n))^2,QUOTIENT(r,(n+1-SEQUENCE(n))^2)},{2,3},false)^{0.5,1})))
- random an array of real triangle sides #BIF #GAS
=LET(a,RANDBETWEEN(1,6),b,RANDBETWEEN(1,6),c,RANDBETWEEN(1,6),{IF(b+c>a,a,MIN(b+c- 1,a)),IF(a+c>b,b,MIN(a+c-1,b)),IF(a+b>c,c,MIN(a+b-1,c))})
=VALUE(TEXTSPLIT(LET(a,RANDBETWEEN(1,10),b,RANDBETWEEN(1,10),c,RANDBETWEEN(1,10),IF(b+c>a,a,MIN(b+c-1,a))&","&IF(a+c>b,b,MIN(a+c-1,b))&","&IF(a+b>c,c,MIN(a+b-1,c))),","))
- convert real number to fraction #BIF #GAS
=ArrayFormula(let(x,A1,n,1000,if(x=FLOOR(x),x,let(nn,SEQUENCE(n),dd,VLOOKUP(1,{BYROW(nn,LAMBDA(d,IF(x*d=FLOOR(x*d),1,0))),nn},2,false),floor(x*dd)&"/"&dd))))
=ArrayFormula(let(x,A1,n,1000,tol,1E-13,if(abs(x-FLOOR(x))<tol,x,let(nn,SEQUENCE(n),dd,VLOOKUP(1,{BYROW(nn,LAMBDA(d,IF(abs(x*d-FLOOR(x*d))<tol,1,0))),nn},2,false),floor(x*dd)&"/"&dd))))
- insert augmented matrix #word
[■(&@&)│■(&@&)]
Report abuse