[201502函初] 第二节作业A组提交贴

橘子红

1.  只要公式,不要附件
2.  修改帖子在原楼
3.  满分+20  +20
4.  提交时间截止下次开课前

suzhouy2003

201502函初：A10

第一题：A3=IF(ROW(A2)<=COLUMN(A1),"",ROW(A1)&"×"&COLUMN(A1)&"="&ROW(A1)*COLUMN(A1))  右拉下拉
             A14=COLUMN(A1)&"×"&ROW(A1)&"="&ROW(A1)*COLUMN(A1) 右拉下拉
第二题：C27=IF(((A27=100)+(B27=100)),"有满分",IF(AND(A27>=90,B27>=90),"优秀","")) 下拉
             D27=IF(OR(A27=100,B27=100),"有满分",IF((A27>=90)*(B27>=90),"优秀","")) 下拉
第三题：C36=IF(B36="未考","缺考",IF(B36>=160,"优秀","")) 下拉
             方法二：C36=TEXT(B36,"[>=160]优秀；；；缺考") 下拉           

沐颜

1. =IF(OR(COLUMN()>ROW()-2,ROW()-2>9),"",COLUMN()&"*"&ROW()-2&"="&COLUMN()*(ROW()-2))

复制代码

1. =COLUMN(A1)&"×"&ROW(A1)&"="&ROW(A1)*COLUMN(A1)

复制代码

1. =IF(OR(A27=100,B27=100),"有满分",IF(AND(A27>89,B27>89),"优秀",""))

复制代码

1. =IF(B36="未考","缺考",IF(B36>159,"优秀",""))

复制代码

xk465592765

1. 第一题
   
2. 答题区一
   
3. =IF(ROW()>24,"",IF(COLUMN(A1)>ROW(A1),"",COLUMN(A1)&"*"&ROW(A1)&"="&COLUMN(A1)*ROW(A1)))
   
4. =IF(COLUMN(A:I)>ROW(1:9),"",COLUMN(A:I)&"*"&ROW(1:9)&"="&COLUMN(A:I)*ROW(1:9))
   
5. 答题区二
   
6. =COLUMN(A1)&"×"&ROW(A1)&"="&COLUMN(A1)*ROW(A1)
   
7. 第二题
   
8. =IF(AND(A27>=90,B27>=90),"优秀","")
   
9. =IF(OR(A27=100,B27=100),"有满分","")
   
10. 第三题
    
11. =IF(IF(SUM(B36)>=160,"优秀","")<>"",IF(SUM(B36)>=160,"优秀",""),IF(B36="未考","缺考",""))

复制代码

rlzcjrrmy

函初[201502]A03 rlzcjrrmy
第一题：A3=IF(COLUMN(A1)<=ROW(A1),COLUMN(A1)&"×"&ROW(A1)&"="&ROW(A1)*COLUMN(A1),"")右拉下拉

第二题：A14=COLUMN(A1)&"×"&ROW(A1)&"="&ROW(A1)*COLUMN(A1)右拉下拉

第三题：AND解法 C27=IF(AND(A27>=90,B27>=90),"优秀","")下拉
            OR解法   D27=IF(OR(A27=100,B27=100),"有满分","")下拉

第四题：C36=IF(ISTEXT(B36),"缺考",IF(B36>=160,"优秀",FALSE))

today0427

A05:TODAY0427
第一题：
答题区一：
=IF(COLUMN(A1)>ROW(A1),"",ROW(A$1)+COLUMN(A1)-1&"×"&ROW(A1)+COLUMN($A1)-1&"="&(ROW(A$1)+COLUMN(A1)-1)*(ROW(A1)+COLUMN($A1)-1))
答题区二：
=ROW(A$1)+COLUMN(A1)-1&"×"&ROW(A1)+COLUMN($A1)-1&"="&(ROW(A$1)+COLUMN(A1)-1)*(ROW(A1)+COLUMN($A1)-1)

第二题：
如果按两道题做就是：
and解法
=IF(AND(A27>=90,B27>=90),"优秀","")
or解法
=IF(OR(A27=100,B27=100),"有满分","")
如果是一道题就是
=IF(OR(A27=100,B27=100),"有满分",IF(AND(A27>=90,B27>=90),"优秀",""))

第三题：
=IF(B36="未考","缺考",IF(B36>=160,"优秀","需努力"))

绵花糖

A组长：绵花糖

1. 第一题
   
2. 1.A3=IF(ROW()-2>=COLUMN(),COLUMN(A1)&"×"&ROW(A1)&"="&ROW(A1)*COLUMN(A1),"")
   
3. 2.A14=COLUMN(A1)&"×"&ROW(A1)&"="&ROW(A1)*COLUMN(A1)
   

复制代码

1. 第二题
   
2. 1.C27==IF(AND(A27>=90,B27>=90),"优秀","")
   
3. 2.D27=IF(OR(A27=100,B27=100),"满分","")

复制代码

1. 第三题
   
2. A36=IF(ISTEXT(B36),"缺考",IF(B36>=160,"优秀",""))

复制代码

llf0516

1、=IF(COLUMN(A1)>ROW(A1),"",COLUMN()&"*"&ROW(A1)&"="&COLUMN(A1)*ROW(A1))
2、=COLUMN()&"*"&ROW(A1)&"="&COLUMN(A1)*ROW(A1)
3、=IF(OR(A27=100,B27=100),"有满分",IF(AND(A27>=90,B27>=90),"优秀"))

4、=IF(B36="未考","缺考",IF(B36>=160,"优秀"))