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

³o¨â­Ó­pºâ¦¡¥i¥H¼g¦¨¤@­Ó¶Ü

³o¨â­Ó­pºâ¦¡¥i¥H¼g¦¨¤@­Ó¶Ü

½Ð°Ý
³o¨â­Ó­pºâ¦¡¥i¥H¼g¦¨¤@­Ó¶Ü¡H
20000*0.001425=28.5¡÷rounddown¬°28¤¸
28*0.8=22.4¡÷rounddown¬°22¤¸

ÁÂÁÂ

¦^´_ 1# coafort

=ROUNDDOWN(ROUNDDOWN(20000*0.001425,)*0.8,)

TOP

¦^´_ 2# aer

¤Ó·PÁ¤j¤j¤F
¥i¥H¥Î¤F:D

TOP

=INT(INT(20000*0.001425)*0.8)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

        ÀR«ä¦Û¦b : ¯àµ½¥Î®É¶¡ªº¤H¡A¥²¯à´x´¤¦Û¤v§V¤Oªº¤è¦V¡C
ªð¦^¦Cªí ¤W¤@¥DÃD