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

[µo°Ý] Excel ¨D±Ð : set formula

[µo°Ý] Excel ¨D±Ð : set formula

¦pªG
Cell A1 = 15,000
Cell B1 = 20,000

·Q§âCell C1 ³]©w¦¨:  (15,000 + 20,000) * 10% µ¥¤_©Î¤Ö¤_2,500

½Ð°Ý Cell C1 ¸Ó¼g¤J¬Æ»ò«ü¥O?

ÁÂÁÂ

=MIN((A1+B1)*10%,2500)
ss

TOP

¦^´_ 2# sunnyso



ÁÂÁÂ: handshake

TOP

=IF((A1+B1)*10%>=2500,2500, (A1+B1)*10%>=2500)
ss

TOP

¤W­±¦³»~

=IF((A1+B1)*10%>=2500,2500, (A1+B1)*10%)
ss

TOP

=--TEXT((A1+B1)*10%/100, "[>25]25")*100
ss

TOP

¦^´_ 1# i421i330

=--((A1+B1)*10%<2500) * (A1+B1)*10% --((A1+B1)*10%>=2500) * 2500
ss

TOP

=CHOOSE((--(A1+B1)*10% > 2500) +1, (A1+B1)*10%, 2500)
ss

TOP

=IFERROR(1/((A1+B1)*10%<2500)*(A1+B1)*10%,2500)
ss

TOP

¤w´ú¸Õ¤F
Cell A1 = 15,000
Cell B1 = 20,000   or  15,000  or 10,000  or 5,000 or 50  (´ú¸Õ¼g¤J¤£¦P¼Æ­È)

     ·Q§âCell C1 ³]©w¦¨: (15,000 + 20,000) * 10% µ¥¤_©Î¤Ö¤_2,500
   
     Cell C1 ¼g¤J¥H¤Uformula,  ­p¥X¨Óªºµª®×¬O¹ïªº :
     =MIN((A1+B1)*10%,2500)
     =IF((A1+B1)*10%>=2500,2500, (A1+B1)*10%)
     =CHOOSE((--(A1+B1)*10% > 2500) +1, (A1+B1)*10%, 2500)
     =--((A1+B1)*10%<2500) * (A1+B1)*10% --((A1+B1)*10%>=2500) * 2500
     =--TEXT((A1+B1)*10%/100, "[>25]25")*100



Cell C1 ¼g¤J¥H¤Uformula,  ­p¥X¨Óªºµª®×¬O¿ùªº : (sunnyso¤W­±¦³»¡©ú¬O¿ùªº)
    =IF((A1+B1)*10%>=2500,2500, (A1+B1)*10%>=2500)

   ÁÂÁÂsunnyso

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD