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

来源：学生作业帮助网编辑：作业帮时间：2024/05/18 23:31:24

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),下拉