在Excel2003中,公式=IF(L4="尾数","不计",IF(BC4>T4,"甩期",IF(BE4>M4*0.02,"甩期","按期"))),

来源:学生作业帮助网 编辑:作业帮 时间:2024/07/13 10:41:09
在Excel2003中,公式=IF(L4=T4,"甩期",IF(BE4>M4*0.02,"甩期","按期")))," />
x){:gkErjkuyMV}ϦnPQzźJ:@q'gSV>3"jbkeg`Wz bhjj$*;kYӳys|L1Wig3=_ b<^O;<hr@Ovc8A "n⊦lB&@D!>zg6p):f>Y<='F 1!

在Excel2003中,公式=IF(L4="尾数","不计",IF(BC4>T4,"甩期",IF(BE4>M4*0.02,"甩期","按期"))),
在Excel2003中,公式=IF(L4="尾数","不计",IF(BC4>T4,"甩期",IF(BE4>M4*0.02,"甩期","按期"))),

在Excel2003中,公式=IF(L4="尾数","不计",IF(BC4>T4,"甩期",IF(BE4>M4*0.02,"甩期","按期"))),
如果L4为尾数,则显示不计
如果L4不为尾数,则判断BC4是不是大于T4,大于T4则显示甩期,不大于则判断B4E是不是大于M4*0.02,大于则显示甩期,不大于显示按期;BC4不大于T4,则直接返回FALSE