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

[µo°Ý] A1 *15«áB1¼Æ­È¤Ö500,¦Û°ÊÂର500,

[µo°Ý] A1 *15«áB1¼Æ­È¤Ö500,¦Û°ÊÂର500,

B1=A1 *15
¦pB1¼Æ­È¤Ö©ó500,¦Û°ÊÂର500.
¦pB1¼Æ­È¤j©ó501-600,¦Û°Ê¥[10%
¦pB1¼Æ­È¤j©ó601-1000,¦Û°Ê¥[15%
¦pB1¼Æ­È¤j©ó1001-1500,¦Û°Ê¥[20%

§ÚÀ³¸Ó¦p¦ó¿é¤J??

·PÁÂ!!!
excel~ ¾Ç¦n¥L§a

B1¼Æ­È¤j©ó1500«ç»òºâ?
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


    ¦]¬°A¦C¤ºªº¼Æ­È¬O»ù¿ú,¤@¯ë¤£¹L¦A¤j¹L100¤º,©Ò¥H X 15«á,¤£·|¤j©ó1500,+10-20% ¥u¬O¹B¶O!!

·PÁÂ!!!
excel~ ¾Ç¦n¥L§a

TOP

¦Û­q¨ç¼Æ¦p¦ó
Function fare(x As Double) As Double
    If x <= 33.33 Then '¤Ö©ó500
        fare = 500
    ElseIf x <= 40 Then '¤¶©ó501-600
        fare = x * 15 * 1.1
    ElseIf x <= 66.67 Then   '¤¶©ó601-1000
        fare = x * 15 * 1.15
    Else    '¤j©ó1001
        fare = x * 15 * 1.2
    End If
End Function

¨Ï¥Î¤èªk:
B1=fare(A1)

TOP

B1=MAX(500,A1*15*LOOKUP(A1*15,{0,501,601,1001},{1,1.05,1.15,1.2}))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ asimov ©ó 2010-6-13 02:27 ½s¿è
B1=MAX(500,A1*15*LOOKUP(A1*15,{0,501,601,1001},{1,1.05,1.15,1.2}))
Hsieh µoªí©ó 2010-6-12 23:26



Hsiehª©¥D¥Îmax§®·¥¤F

¶Ç²Î°µªk
b1=IF(A1*15<500,500,A1*15*VLOOKUP(A1*15,{501,1.1;601,1.15;1001,1.2},2))
´NÅã±o¤FµL·s·N¤F
¾÷¾¹¤H¤T¤j©w«ß-«OÅ@¤HÃþ¡BªA±q©R¥O¡B«OÅ@¦Û¤v
§Úªº¤T¤j©w«ß-¥Í©R¡B¥Í¦s¡B¥Í¬¡

TOP

hsieh ª©¥D¤èªk¥Îªº§®

B1

=MAX(500,A1*15*LOOKUP(A1*15,{0,501,601,1001},{0,1.1,1.15,1.2}))
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¡i¬°µ½Ävª§¡j¤H¥Í­n¬°µ½Ävª§¡A¤À¬í¥²ª§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD