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

IF ¨ç¼Æ

IF ¨ç¼Æ

½Ð°ÝIF¨ç¼Æ,¦p¬O¿ù»~®É, ¬OÅã¥Ü¬°0, ¦Ó¤£¬OFalse.
Book.zip (1.86 KB)

¥»©«³Ì«á¥Ñ ANGELA ©ó 2012-9-29 23:58 ½s¿è

=IF(B5>1,IF(B5<=30,C5,0),0)
¥H¤W¬O²Å¦XIF()ªº³W«h
¨ä¹ê³o­Ó¦a¤è¨Ã¤£»Ý­n¥Î¨ì¨ç¼Æ
=(B5>1)*(B5<=30)*C5 §Y¥iº¡¨¬.

TOP

©ÎªÌ

=IF((B5>1)*(B5<31),C5,0)

©ÎªÌ

=IF(ABS(B5-16)<15,C5,0)

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD