多项选择题
在EXCEL某工作表中的F26单元格中存放有数值数据,现在要在G26单元格中输入公式,根据F26中的数据情况,判断它是正、负、零。G26中正确的公式是( )。
A、=IF(F26>0,"正",IF(F26<0,"负","零"))
B、=IF(F260,"正","零"))
C、=IF(F26=0,"零",IF(F26>0,"正","负"))
D、=IF(F26<=0,IF(F260,"负","零"),"正")
E、=IF(F26>=0,IF(F26>0,"正","零"),"负")
点击查看答案&解析
