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

§xÂZªº EXCEL ( IF)

§xÂZªº EXCEL ( IF)

¤W¯Z        ¤U¯Z
8        21

=IF(((Q2-P2)>8),8,
IF(Q2=0,0,
IF(P2=0,0,
IF((AND(P2<12,Q2>12)),(SUM(Q2-P2-1)),(SUM(Q2-P2))))))

°²³]
¤U¯Z-¤W¯Z  ¤j©ó8  ´N¥Î8­pºâ
¦pªG¥ô¦ó¤@®æµ¥©ó0 ¥Î0­pºâ
¦pªG¤W¯Z¤p©ó12¤U¯Z¤j©ó12 «h¤U¯Z-¤W¯Z¦A´î1
³£¤£¬Oªº¸Ü«h¤U¯Z-¤W¯Z

¤W­±ªº­pºâµ²ªG ³o¼Ë¥¿½T¹À!?
Cyssuc

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-9-8 23:46 ½s¿è

¦^´_ 1# Cyssuc
1. ²Ä¤G¶µ¥ô¦ó¤@®æµ¥©ó0 ¥i¥Î OR(Q2=0,P2=0) ¨Ó¹ê²{.
2. ¥u¦³¨â­ÓÀx¦s®æ¶¡ªº­pºâ, ¦ü¥G¤£¥Î¥Î¨ì SUM ¨ç¼Æ.

©Ò¥H¥i±o :

=IF((Q2-P2)>8,8,IF(OR(Q2=0,P2=0),0,IF(AND(P2<12,Q2>12),Q2-P2-1,Q2-P2)))

TOP

¦^´_ 2# luhpro


    8        14.5
µª®×À³¸Óµ¥©ó14.5-8-1
¬Gµ¥©ó5.5

°ÝÃD¬O «ö¤W¤è¦Cªí­pºâµª®×¬O6.5   ©Ò¥H¯Ç´e¡C¡C¡C

½Ð±z¬O§_¥i¥H¦b¸Ñµª¤@¦¸©O?!
Cyssuc

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2014-9-9 09:20 ½s¿è

¦^´_ 1# Cyssuc

¦­¤W 8~12¡A¤U¤È 13~17

= ¦­¤W®É¼Æ + ¤U¤È®É¼Æ
= MAX(0,MIN(12,Q2)-MAX(8,P2)) + MAX(0,MIN(17,Q2)-MAX(13,P2))

©Î
=IF(AND(P2>0,Q2>0), MAX(0,MIN(12,Q2)-MAX(8,P2)) + MAX(0,MIN(17,Q2)-MAX(13,P2)), "")
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# ML089


    ¦pªG¦­¤W8ÂI
¤¤¤È12ÂI¤U¯Z

¨â­Ó¤½¦¡ »ª¦ü³£·|¿ù»~

³Â·Ð¤F
Cyssuc

TOP

¦^´_ 5# Cyssuc

³o¼Ë­þ¸Ì¦³¿ù?
20140909.jpg
2014-9-9 15:23
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# Cyssuc

    8        14.5
µª®×À³¸Óµ¥©ó14.5-8-1
¬Gµ¥©ó5.5

2014090901.jpg
2014-9-9 16:09
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089


   
    §Ú·Q­úªº­ì¦]¡C¡C¡C¡C

§Ú·Q­úªº­ì¦]¡C¡C¡C¡C

0000.png
Cyssuc

TOP

¦^´_ 8# Cyssuc

¥i¯à»Ý­n«öF9­«·s­pºâ

¤£µM±N³¡¤À¸ê®ÆÀɮפW¶Ç¡A§ÚÀ°§A¬Ý¬Ý°ÝÃD¦b­þ¸Ì
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2014-9-9 22:21 ½s¿è
¦^´_  luhpro
    8        14.5
µª®×À³¸Óµ¥©ó14.5-8-1
¬Gµ¥©ó5.5
°ÝÃD¬O «ö¤W¤è¦Cªí­pºâµª®×¬O6.5   ©Ò ...
Cyssuc µoªí©ó 2014-9-9 08:18

«x?
§Úªº¹q¸£ºâ¥X¨Ó¬O¹ïªº­C...
Q2-P2-1.png
2014-9-9 22:09


¦^´_  ML089
    §Ú·Q­úªº­ì¦]¡C¡C¡C¡C
Cyssuc µoªí©ó 2014-9-9 17:00

¸Ü»¡ªí­±¤W¬Ý¤£¥X¨Ó°ÝÃDÂI,
¬O§_§A¥i¥H§â P50 »P Q 50 ªº¤½¦¡¤]¨q¥X¨Ó¬Ý¬Ý.
ÁÙ¦³§A¥i¥H´ú´ú¬Ý±N P50 »P Q50 ¨â­ÓÀx¦s®æ³£¥ý§R°£­È,
¦A±N®æ¦¡§ï¬° "G/³q¥Î®æ¦¡",
³Ì«á¤À§O¥´¤W 13 »P 17 ¨â­Ó¾ã¼Æ¼Æ­ÈÂл\¤W¥h¬Ý¬Ý¬O§_ O50 ªºµ²ªG·|ÅÜ¥¿±`..

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD