=IF(AND($A3"",B$2"",B$2
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/13 06:51:29
![=IF(AND($A3](/uploads/image/z/5536823-23-3.jpg?t=%3DIF%28AND%28%24A3%22%22%2CB%242%22%22%2CB%242)
x)tpsPq4VRqR16IE8l|f O;{_]l'=i';u|.Gӝtg3yj@γiy@t5y0W鞩O?mk}c[@u
xwm ?ٽ/M~ں p
M<; r}7
=IF(AND($A3"",B$2"",B$2
=IF(AND($A3"",B$2"",B$2
=IF(AND($A3"",B$2"",B$2
符合前面条件的情况下,显示A3×B2也就是3×2
&是文本连接符,“”,引号内为直接显示的文本
当然也可以在A1输入
=IF(ROW()