excel中A1数值大于0时B1自动输入工作认真,A1数值小于0时,B1自动输入工作不认真,A1等于0或者是空,B1没有内容
=IF(A1>0,"工作认真",IF(A1<0,"工作不认真",""))
=IF(A1>0,"工作认真",IF(OR(A1=0,A1=""),"","工作不认真"))