Excel 求助公式两个 A1有数值2到10

发布网友发布时间：2022-04-24 05:52

共4个回答

热心网友时间：2023-07-22 01:37

公式一：
=if(A1<=5,"小","大")

要求二：
在B1中输入以下公式
=choose(column(A:A),if(or($A1={2,3,4}),"小",""),if(or($A1={5,6,7}),"中",""),if(or($A1={8,9,10}),"大",""))
向右向下填充

热心网友时间：2023-07-22 01:37

=IF(A1<6,"小","大")
=IF(INT(($A1+1)/3)=COLUMN(A1),CHOOSE(INT(($A1+1)/3),"小","中","大"),"")

热心网友时间：2023-07-22 01:38

=TEXT(A1-5.5,"大;小;")
B1=TEXT(INT((A1-2)/3)-1,";小;")
C1=TEXT(INT((A1-2)/3)-1,";;中")
D1=TEXT(INT((A1-2)/3)-1,"大;;")

热心网友时间：2023-07-22 01:38

=IF(A1<6,"小","大")
=if(a1>7,"大",if(a1<5,"小","中"))

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com