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

[µo°Ý] ³]©w«ü©w½d³ò(¶Ã¼Æ)

[µo°Ý] ³]©w«ü©w½d³ò(¶Ã¼Æ)

³]©w«ü©w½d³ò(¶Ã¼Æ),»Ý¨D¦p¤U¹Ï

180906 Test.zip (19.19 KB)

¦^´_ 1# dea172

¤½¦¡:
¥Ø«e¥u¯à³]¤W­­
=IF(Input!F4="","",ROUND(Input!F4+RAND()*0.003,3))
­Y·Q§ï¬°¥i¨Ì·Ó "Input!F4" ³]©w¤W­­»P¤U­­¸Ó¦p¦ó§ó§ï¤½¦¡

TOP

¤W¤U¤d¤À¤§3???
=IF(Input!F4="","",ROUND(Input!F4+(3-INT(RAND()*7))/1000,3))

TOP

¦^´_ 3# ­ã´£³¡ªL

ª©¥D§A¦n,
§Úªº»Ý¨D¦p¤U
Input-1 ¼Æ­È·|¸òÀH Input¦Ó¶Ã¼Æ¸õ°Ê(¦ý»Ý©ó¤@­Ó½d³ò¤º¸õ°Ê)
Ex : Input "A4" Äæ¦ì¬° 12.768, Input-1 "A4"Äæ¦ì¼Æ­È¶Ã¼Æ²£¥Í(¦ý»Ý©ó-0.03 ©Î¬O +0.03 ½d³ò¤º¶Ã¼Æ²£¥Í,§Y12.738 ~ 12.798)

TOP

¦^´_ 4# dea172

¥¿­t ¦Ê¤À¤§3 ???
=IF(Input!F4="","",ROUND(Input!F4+(3-INT(RAND()*7))/100,3))

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2018-9-7 09:52 ½s¿è

2007ª©=IF(Input!F4="","",Input!F4+(RANDBETWEEN(1,7)-4)/100)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 5# ­ã´£³¡ªL

=IF(Input!F4="","",ROUND(Input!F4+(3-INT(RAND()*7))/100,3))
**********************************************************************
ª©¥D§A¦n,
(3-INT(RAND()*7))/100
½Ð°Ý³o¥y昰¤°»ò·N«ä, ¬O§_¥i¸ÑÄÀ? ÁÂÁÂ

TOP

¥»©«³Ì«á¥Ñ dea172 ©ó 2018-9-7 12:37 ½s¿è

¦^´_ 6# hcm19522


=IF(Input!F4="","",Input!F4+(RANDBETWEEN(1,7)-4)/100)
******************************************************************
(RANDBETWEEN(1,7)-4)/100)
½Ð°Ý³o¥y¦h¤F -4 昰¤°»ò·N«ä, ¬O§_¥i¸ÑÄÀ? ÁÂÁÂ

TOP

¦^´_ 8# dea172

RANDBETWEEN(1,7)²£¥Í 1~7--> -4--> -3~3
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 9# hcm19522

§A¦n,
ÁÂÁ­ì¨Ó¬O³o¼Ë¨Ï¥Îªº

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD