A -B=C C>0则显示OK,C

来源：学生作业帮助网编辑：六六作业网时间：2024/11/28 01:21:24

A-B=CC>0则显示OK,CA-B=CC>0则显示OK,CA-B=CC>0则显示OK,C在D1单元格输入=if(a1-b1>=0,"OK","NO"),下拉即可,在E1单元格输入=if(c1="OK

A -B=C C>0则显示OK,C
A -B=C C>0则显示OK,C

A -B=C C>0则显示OK,C
在D1单元格输入=if(a1-b1>=0,"OK","NO"),下拉即可,在E1单元格输入=if(c1="OK",A1*2+B1*8,A1*1+B1*5),下拉