要求在excel的单元格中输入一个数字。如果不是数字或没有输入,请在提示时输入数字。
1.在单元格A9中输入公式:=IF(OR(A8= "),NOT(ISNUMBER(A8)),“请在单元格A8(或C8)中输入一个数字”," ");
2.在B9单元格中输入公式:= if (not (or (B8 = "+",b8 = "-",b8 = "* ",b8 = "/),“请在B8单元格中输入运算符号”," ");
3.在单元格C9中输入公式:=IF(OR(C8= "),NOT(ISNUMBER(C8))),“请在单元格A8(或C8)"中输入一个数字”," ");
4.在单元格D9中输入公式:=IF(D8= ","请在单元格E8中输入答案",IF(B8="+",IF(D8=A8+C8," Great "," Keep work "),IF (B8 = "-",IF (D8 = IF(B8="/",IF(D8=A8/C8," Great "," Keep work "),"请在B8单元格中输入运算符号));
就可以完成上面说的“四则算术兴趣练习游戏”啦!