请问excel通过公式实现以下功能？ 如果A2-1<2,A1则显示X 如果A2-1>=2,A1则显示Y 如果A2为空，A1则显示空

Question

如题所述

Answer 1

A1输入：
=if(A2<3,"X",if(A2>=3,"Y","")

Answer 2

=if(A2="","",if(A2<3,"X","Y"))

Answer 3

=if(a1="","",if(a1<3,"X","Y")