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

IF »P¦h¶µ±ø¥ó­È¤½¦¡

IF »P¦h¶µ±ø¥ó­È¤½¦¡

·Q½Ð°Ý¤@¤U,¦pªG­n±qA1Àx¦s®æ¤å¦r¦h­Ó²Å¦X±ø¥ó­È°µ¤ÀÃþ,§Ú¼g¤F¥H¤U¤½¦¡,¥i¬OÁÙ¬O¥N¤£¥X­È¨Ó,
½Ð°Ý¸Ó¦p¦ó­×¥¿©O? TKS.

=IF(OR(A1=¡¨AA¡¨,A1=¡¨BB¡¨,A1=¡¨CC¡¨),"²Ä¤@³¡",IF(A1=¡¨DD¡¨),"²Ä¤G³¡"))

A1
AA²Ä¤@³¡
BB²Ä¤@³¡
CC²Ä¤@³¡
DD²Ä¤G³¡

=IF(OR(A1="AA",A1="BB",A1="CC"),"²Ä¤@³¡",IF(A1="DD","²Ä¤G³¡",""))

TOP

        ÀR«ä¦Û¦b : ¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD