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

[µo°Ý] ¹F¦¨²v¼úª÷­pºâ

=LOOKUP(E4,{0,40,70,80,90,100},{0,4,8,11,14,17}*1000)*MIN(C44)*MAX(1,MIN(1.1,E4%))+MAX(0,(D4-C4*1.1)*20000)+MAX(0,(D4-C4*1.1-1)*2000)

0~40% ¥¼©w¸q ?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD