ªð¦^¦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)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

        ÀR«ä¦Û¦b : ¤â¤ß¦V¤U¬O§U¤H¡A¤â¤ß¦V¤W¬O¨D¤H¡F§U¤H§Ö¼Ö¡A¨D¤Hµh­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD