ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¼Æ­È¬Û®t§PÂ_

[µo°Ý] ¼Æ­È¬Û®t§PÂ_

¤T­Ó¼Æ­È
A 0.012
B 0.017
C 0.013
D
¼Æ­È¨C¦¸³£·|¤£¦P
¤T­Ó¼Æ­È¬Û®t5¥H¤WD¦sÀx®æ¥X²{ĵ§i¡A¦³¤°»ò¨ç¼Æ¬O­pºâ¬Û®tªº¶Ü?

¦]¬°§Ú¥ÎA-B =0.005  ¦ýB-A = ­t0.005¡A¥i¥H§â¥¦Åܦ¨¨S¦³­tªº¶Ü?
¦]¬°§Ú³o¼Ë´N¥i¥H¼gIF§PÂ_A-B & A-C & B-C ¤j©ó5´N¥X²{ĵ§i

¦³¤j¤j¦³§ó¦nªº«Øij¶Ü?

¤T­Ó¼Æ­È
A 0.012
B 0.017
C 0.013
D
¼Æ­È¨C¦¸³£·|¤£¦P
¤T­Ó¼Æ­È¬Û®t5¥H¤WD¦sÀx®æ¥X²{ĵ§i¡A¦³¤°»ò¨ç ...
mark761222 µoªí©ó 2015-10-9 16:37


¥Îabs¨ç¼Æ¡A¨úµ´¹ï­È

TOP

http://blog.xuite.net/hcm19522/twblog/348297137

TOP

·PÁ¦U¦ìÀ°¦£
¨Ì·Ó¤G¼Ó´£¨Ñªº¿ìªk¡A§Úªºµ{¦¡¦p¤U
A1 0.012
A2 0.017
A3 0.013
A4 µ{¦¡¦p¤U
=IF(AND(ABS(A1-A2)<0.005,ABS(A1-A3)<0.005,ABS(A2-A3)<0.005),"OK","NG")
¤w¸Ñ¨M§Úªº°ÝÃD

TOP

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2015-10-9 18:36 ½s¿è

¤p¼ÆÂIºâ¦¡¡A¥i¯à³y¦¨¡e¯BÂI¼Æ¡f¡A·|¦³»~®t¡A
¢Ï¢°¡G0.027
¢Ï¢±¡G0.022

¢Ï¢³¡G=A1-A2¡@¡÷¶K¤W­È¬Ý¬Ý¡@0.00499999999999999
¢Ï¢´¡G=ROUND(A1-A2,3)

¥t¡Dµ¹­Ó·Qªk¡G
=ROUND(³Ì¤j­È - ³Ì¤p­È,3) < 0.005

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD