²é¿´: 1496  |  »Ø¸´: 5

newton2006

Í­³æ (ÕýʽдÊÖ)

[ÇóÖú] excel±íÖÐ ÊäÈ빫ʽÐèÓöà²ãIFº¯ÊýÎÊÌâ

ÔÚ¸½¼þexcel ±íÖÐ ÏëʵÏÖA2µ¥Ôª¸ñСÓÚµÈÓÚ0.05»òÕßµÈÓÚ''0.01L¡°Ê±£¬ÔÚA3µ¥Ôª¸ñµÈÓÚ¡°¢ñ¡±£¨ÂÞÂíÊý×Ö¢ñ£©£¬Ò²¾ÍÊÇÔÚÎÒ±àµÄ¹«Ê½¡°=IF(A2<=0.05,"¢ñ",IF(A2<=0.5,"¢ô",IF(A2<=1,"¢õ","ÁÓ¢õ"))  ÖеÚÒ»²ãifº¯ÊýIF(A2<=0.05,"¢ñ",¸ÃÈçºÎÐ޸ģ¬Çë¸ßÊÖÖ¸½Ì£¬·Ç³£¸Ðл¡£[ Last edited by newton2006 on 2012-12-25 at 23:04 ]
»Ø¸´´ËÂ¥

» ±¾Ìû¸½¼þ×ÊÔ´Áбí

  • »¶Ó­¼à¶½ºÍ·´À¡£ºÐ¡Ä¾³æ½öÌṩ½»Á÷ƽ̨£¬²»¶Ô¸ÃÄÚÈݸºÔð¡£
    ±¾ÄÚÈÝÓÉÓû§×ÔÖ÷·¢²¼£¬Èç¹ûÆäÄÚÈÝÉæ¼°µ½ÖªÊ¶²úȨÎÊÌ⣬ÆäÔðÈÎÔÚÓÚÓû§±¾ÈË£¬Èç¶Ô°æÈ¨ÓÐÒìÒ飬ÇëÁªÏµÓÊÏ䣺xiaomuchong@tal.com
  • ¸½¼þ 1 : ±í1.xls
  • 2012-12-25 22:58:41, 15 K

» ²ÂÄãϲ»¶

» ±¾Ö÷ÌâÏà¹Ø¼ÛÖµÌùÍÆ¼ö£¬¶ÔÄúͬÑùÓаïÖú:

ÐÐÒ»²»Ò壬ɱһ²»¹¼£¬¶øµÃÌìÏ£¬½Ô²»ÎªÒ²£¡
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

newton2006

Í­³æ (ÕýʽдÊÖ)

¹«Ê½ºóÃæ±¾ÊÇ3¸ö¡°)¡±,²»ÖªÔõô»ØÊ³öÀ´¸ö¿ÞÁ³
ÐÐÒ»²»Ò壬ɱһ²»¹¼£¬¶øµÃÌìÏ£¬½Ô²»ÎªÒ²£¡
2Â¥2012-12-25 23:06:34
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

newton2006

Í­³æ (ÕýʽдÊÖ)

Ò²¾ÍÊÇÍêÕûµÄ¹«Ê½ÒªÊµÏÖÒÔÏÂÄ¿±ê£º
A2                                              A3=
A2 ¡Ü0.05                                             ¢ñ
A2 =0.01L                                            ¢ñ
0.05£¼A2¡Ü0.5                                   ¢ô
0.5£¼A2¡Ü1                                       ¢õ
1£¼A2                                             ÁÓ¢õ         

Ò²¾ÍÊÇ   1  µ±A2 ¡Ü0.05     »òÕßµÈÓÚ 0.01L      Ê± A3=¢ñ£»      
         2   µ±0.05£¼A2¡Ü0.5   Ê± A3=¢ô£»
         3  µ±0.5£¼A2¡Ü1   Ê± A3=¢õ£»
         4  µ±1£¼A2     Ê±  A3=¡°ÁÓ¢õ¡±
ÐÐÒ»²»Ò壬ɱһ²»¹¼£¬¶øµÃÌìÏ£¬½Ô²»ÎªÒ²£¡
3Â¥2012-12-25 23:24:06
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

615780236

½û³æ (ÖªÃû×÷¼Ò)

¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
±¾ÌûÄÚÈݱ»ÆÁ±Î

4Â¥2012-12-26 08:26:25
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

csgt0

ÈÙÓþ°æÖ÷ (ÖøÃûдÊÖ)

²ÊÉ«¹Òͼ

¡¾´ð°¸¡¿Ó¦Öú»ØÌû

¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï ¡ï
¸Ðл²ÎÓ룬ӦÖúÖ¸Êý +1
newton2006: ½ð±Ò+10, ¡ï¡ï¡ï¡ï¡ï×î¼Ñ´ð°¸, °´ÄãµÄÌáʾ£¬ÎÊÌâµÃµ½½â¾ö£¬Ð»Ð» 2012-12-26 20:32:56
Äã¿ÉÒÔÓÃÌõ¼þ¸ñʽ£¬¿ÉÒÔÓÃVBA£¬µ±È»Ò²¿ÉÒÔÓÃIF
CODE:
=IF(A1="0.01L","¢ñ",IF(A1<=0.05,"I",IF(A1<=0.5,"IV",IF(A1<=1,"V","ÁÓV"))))

½á¹ûÈçÏ£º
A ÁР     BÁР 
0.02        I
0.01L        ¢ñ
0.06        IV
0.5        IV
0.8        V
1        V
2        ÁÓV
showmethemoney
5Â¥2012-12-26 11:17:17
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû

newton2006

Í­³æ (ÕýʽдÊÖ)

°´5Â¥µÄ·½·¨£¬ÎÊÌâµÃµ½½â¾ö
ÐÐÒ»²»Ò壬ɱһ²»¹¼£¬¶øµÃÌìÏ£¬½Ô²»ÎªÒ²£¡
6Â¥2012-12-26 20:34:38
ÒÑÔÄ   »Ø¸´´ËÂ¥   ¹Ø×¢TA ¸øTA·¢ÏûÏ¢ ËÍTAºì»¨ TAµÄ»ØÌû
Ïà¹Ø°æ¿éÌø×ª ÎÒÒª¶©ÔÄÂ¥Ö÷ newton2006 µÄÖ÷Ìâ¸üÐÂ
×î¾ßÈËÆøÈÈÌûÍÆ¼ö [²é¿´È«²¿] ×÷Õß »Ø/¿´ ×îºó·¢±í
[¿¼ÑÐ] 324·Ö 085600²ÄÁÏ»¯¹¤Çóµ÷¼Á +4 llllkkkhh 2026-03-18 4/200 2026-03-21 01:24 by JourneyLucky
[¿¼ÑÐ] ¡¾¿¼Ñе÷¼Á¡¿»¯Ñ§×¨Òµ 281·Ö£¬Ò»Ö¾Ô¸ËÄ´¨´óѧ£¬³ÏÐÄÇóµ÷¼Á +8 ³Ô³Ô³Ô²ÅÓÐÒâÒå 2026-03-19 8/400 2026-03-21 00:49 by Áõ¹úÉ­
[¿¼ÑÐ] Çóµ÷¼ÁÒ»Ö¾Ô¸ÄϾ©º½¿Õº½Ìì´óѧ289·Ö +3 @taotao 2026-03-19 3/150 2026-03-20 21:34 by JourneyLucky
[¿¼ÑÐ] Ò»Ö¾Ô¸Î÷ÄϽ»Í¨ ר˶ ²ÄÁÏ355 ±¾¿ÆË«·Ç Çóµ÷¼Á +5 Î÷ÄϽ»Í¨×¨²Ä355 2026-03-19 5/250 2026-03-20 21:10 by JourneyLucky
[¿¼ÑÐ] 261ÇóBÇøµ÷¼Á£¬¿ÆÑо­Àú·á¸» +3 Å£Ä̺Üæ 2026-03-20 4/200 2026-03-20 19:34 by JourneyLucky
[¿¼ÑÐ] 281Çóµ÷¼Á£¨0805£© +14 ÑÌÏ«Ò亣 2026-03-16 25/1250 2026-03-20 15:47 by yuncha
[¿¼ÑÐ] ²ÄÁÏѧ˶318Çóµ÷¼Á +5 February_Feb 2026-03-19 5/250 2026-03-19 23:51 by 23Postgrad
[¿¼ÑÐ] Áº³ÉΰÀÏʦ¿ÎÌâ×é»¶Ó­ÄãµÄ¼ÓÈë +9 һѼѼӴ 2026-03-14 11/550 2026-03-19 17:22 by £¡±¾°µÒ»´Î£¡
[¿¼ÑÐ] 085600²ÄÁÏÓ뻯¹¤µ÷¼Á 324·Ö +10 llllkkkhh 2026-03-18 12/600 2026-03-19 14:33 by llllkkkhh
[¿¼ÑÐ] Ò»Ö¾Ô¸¸£´ó288Óлú»¯Ñ§£¬Çóµ÷¼Á +3 Сľ³æ200408204 2026-03-18 3/150 2026-03-19 13:31 by houyaoxu
[¿¼ÑÐ] ²ÄÁÏ¿¼Ñе÷¼Á +3 xwt¡£ 2026-03-19 3/150 2026-03-19 11:22 by wãåÑôw
[¿¼ÑÐ] 328Çóµ÷¼Á£¬Ó¢ÓïÁù¼¶551£¬ÓпÆÑо­Àú +4 ÉúÎ﹤³Ìµ÷¼Á 2026-03-16 12/600 2026-03-19 11:10 by ÉúÎ﹤³Ìµ÷¼Á
[¿¼ÑÐ] ¡¾Í¬¼ÃÈí¼þ¡¿Èí¼þ£¨085405£©¿¼ÑÐÇóµ÷¼Á +3 2026eternal 2026-03-18 3/150 2026-03-18 19:09 by ²«»÷518
[¿¼ÑÐ] ²ÄÁÏר˶306Ó¢Ò»Êý¶þ +10 z1z2z3879 2026-03-16 13/650 2026-03-18 14:20 by 007_lilei
[¿¼ÑÐ] ÊÕ¸´ÊÔµ÷¼ÁÉú +4 ÓêºóÇïºÉ 2026-03-18 4/200 2026-03-18 14:16 by elevennnne
[¿¼ÑÐ] 299Çóµ÷¼Á +5 ¡÷С͸Ã÷* 2026-03-17 5/250 2026-03-18 11:49 by ¾¡Ë´Ò¢1
[¿¼ÑÐ] ÉúÎïѧ071000 329·ÖÇóµ÷¼Á +3 ÎÒ°®ÉúÎïÉúÎﰮΠ2026-03-17 3/150 2026-03-18 10:12 by macy2011
[¿¼ÑÐ] Ò»Ö¾Ô¸ÄϾ©´óѧ£¬080500²ÄÁÏ¿ÆÑ§Ó빤³Ì£¬µ÷¼Á +4 Jy? 2026-03-16 4/200 2026-03-17 11:02 by gaoqiong
[¿¼ÑÐ] 327Çóµ÷¼Á +6 ʰ¹âÈÎȾ 2026-03-15 11/550 2026-03-15 22:47 by ʰ¹âÈÎȾ
[¿¼ÑÐ] 297Ò»Ö¾Ô¸ÉϽ»085600Çóµ÷¼Á +5 Ö¸¼â°ËǧÀï 2026-03-14 5/250 2026-03-14 17:26 by a²»Ò×
ÐÅÏ¢Ìáʾ
ÇëÌî´¦ÀíÒâ¼û