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

½Ð°Ý­pºâ¦¡¦³¿ìªk²¤Æ¶Ü

½Ð°Ý­pºâ¦¡¦³¿ìªk²¤Æ¶Ü

=IF(ROUNDDOWN(A3*B3*1000*G$1%,)-ROUNDDOWN(ROUNDDOWN(A3*B3*1000*G$1%,)*((100-E$1)%),0)<C$1,C$1,ROUNDDOWN(A3*B3*1000*G$1%,)-ROUNDDOWN(ROUNDDOWN(A3*B3*1000*G$1%,)*((100-E$1)%),0))

½Ð°Ý³o­pºâ¦¡¦³¿ìªk²¤Æ¶Ü
ÁÂÁÂ

=MAX(C$1,SUM(ROUNDDOWN(ROUNDDOWN(A3*B3*10*G$1,)*({1,-1}+E$1%*{0,1}),0)))

TOP

=MAX(C$1,SUM(ROUNDDOWN(ROUNDDOWN(A3*B3*10*G$1,)*({1,-1}+E$1%*{0,1}),0)))
­ã´£³¡ªL µoªí©ó 2022-12-9 20:01



¤Ó·PÁ¤j¤j¤F
¤Ó¯«¤F:lol

TOP

        ÀR«ä¦Û¦b : ¤£­n¤p¬Ý¦Û¤v¡A¦]¬°¤H¦³µL­­ªº¥i¯à¡C
ªð¦^¦Cªí ¤W¤@¥DÃD