EXCEL中,在某个单元格中连续几个IF语句得出的内容用什么符号连在一起
发布网友
共2个回答
热心网友
="定期复查"&if(B3="血常规","血常规，","")&if(B4="尿常规","尿常规，","")&if(B5="肝功能","肝功能，","")&if(B6="肾功能","肾功能，","")&if(B7="血脂","血脂，","")&if(B8="血溏","血糖，","")&if(B9="肝脏B超","肝脏B超","")
if语句
if(条件，条件成立返回真，条件不成立返回假)
如if(B3=B3,"1","2")这里的逗号和双引号必须在英文输入方式下，而两个双引号之间的内容中英文输入皆可。该语句条件成立，即返值为1；
再如if(B3>B3,"1","2")该语句条件不成立，即返回值为2。
热心网友
满足两个条件使用AND，例如：
=IF(AND(A1>0,A1<10),"0-10之间","其它")
热心网友
满足两个条件使用AND，例如：
=IF(AND(A1>0,A1<10),"0-10之间","其它")
热心网友
="定期复查"&if(B3="血常规","血常规，","")&if(B4="尿常规","尿常规，","")&if(B5="肝功能","肝功能，","")&if(B6="肾功能","肾功能，","")&if(B7="血脂","血脂，","")&if(B8="血溏","血糖，","")&if(B9="肝脏B超","肝脏B超","")
if语句
if(条件，条件成立返回真，条件不成立返回假)
如if(B3=B3,"1","2")这里的逗号和双引号必须在英文输入方式下，而两个双引号之间的内容中英文输入皆可。该语句条件成立，即返值为1；
再如if(B3>B3,"1","2")该语句条件不成立，即返回值为2。
热心网友
满足两个条件使用AND，例如：
=IF(AND(A1>0,A1<10),"0-10之间","其它")
热心网友
="定期复查"&if(B3="血常规","血常规，","")&if(B4="尿常规","尿常规，","")&if(B5="肝功能","肝功能，","")&if(B6="肾功能","肾功能，","")&if(B7="血脂","血脂，","")&if(B8="血溏","血糖，","")&if(B9="肝脏B超","肝脏B超","")
if语句
if(条件，条件成立返回真，条件不成立返回假)
如if(B3=B3,"1","2")这里的逗号和双引号必须在英文输入方式下，而两个双引号之间的内容中英文输入皆可。该语句条件成立，即返值为1；
再如if(B3>B3,"1","2")该语句条件不成立，即返回值为2。
热心网友
满足两个条件使用AND，例如：
=IF(AND(A1>0,A1<10),"0-10之间","其它")
热心网友
="定期复查"&if(B3="血常规","血常规，","")&if(B4="尿常规","尿常规，","")&if(B5="肝功能","肝功能，","")&if(B6="肾功能","肾功能，","")&if(B7="血脂","血脂，","")&if(B8="血溏","血糖，","")&if(B9="肝脏B超","肝脏B超","")
if语句
if(条件，条件成立返回真，条件不成立返回假)
如if(B3=B3,"1","2")这里的逗号和双引号必须在英文输入方式下，而两个双引号之间的内容中英文输入皆可。该语句条件成立，即返值为1；
再如if(B3>B3,"1","2")该语句条件不成立，即返回值为2。
热心网友
满足两个条件使用AND，例如：
=IF(AND(A1>0,A1<10),"0-10之间","其它")
