Bạn đang có hai cạnh của tam giác vuông và muốn tìm cạnh còn thiếu (số nguyên). Với Excel bạn có thể dễ dàng:
Link: Onedrive
Công thức:
1.=IFERROR(AGGREGATE(14,6,SQRT(B2^2+{1,-1}*A2^2)/(MOD(SQRT(B2^2+{1,-1}*A2^2),1)=0),1),"NA")
2.=IFNA(LOOKUP(1,0/(MOD(SQRT(ABS(MMULT(A2:B2^2*{1,1;1,-1},{1;1}))),1)=0),SQRT(ABS(MMULT(A2:B2^2*{1,1;1,-1},{1;1})))),"NA")
3.=BYROW(SQRT(ABS(MMULT(A2:B16^2,{1,1;1,-1}))),LAMBDA(x,REDUCE("NA",x,LAMBDA(s,r,IF(MOD(r,1),s,r)))))
4.=MAP(A2:A16,B2:B16,LAMBDA(x,v,LET(a,VSTACK(SQRT(x^2+v^2),SQRT(ABS(x^2-v^2))),XLOOKUP(0,MOD(a,1),a,"NA"))))
1.=IFERROR(AGGREGATE(14,6,SQRT(B2^2+{1,-1}*A2^2)/(MOD(SQRT(B2^2+{1,-1}*A2^2),1)=0),1),"NA")
2.=IFNA(LOOKUP(1,0/(MOD(SQRT(ABS(MMULT(A2:B2^2*{1,1;1,-1},{1;1}))),1)=0),SQRT(ABS(MMULT(A2:B2^2*{1,1;1,-1},{1;1})))),"NA")
3.=BYROW(SQRT(ABS(MMULT(A2:B16^2,{1,1;1,-1}))),LAMBDA(x,REDUCE("NA",x,LAMBDA(s,r,IF(MOD(r,1),s,r)))))
4.=MAP(A2:A16,B2:B16,LAMBDA(x,v,LET(a,VSTACK(SQRT(x^2+v^2),SQRT(ABS(x^2-v^2))),XLOOKUP(0,MOD(a,1),a,"NA"))))