№1
76 (C1=A1+B1=A1+A1*3+12=4*A1+12=76)
№2
107 (=A2+B2)
180 (=A3+B3)
№3
160 (=С1+B1=A1+B1+B1)
159 (=С2+B2=A2+B2+B2)
246 (=С3+B3=A3+B3+B3)
№4
230 (=$A$1+B1)
260 (=$A$1+B2)
265 (=$A$1+B3)
№5
1562 (=D2*D1=MIN(A1:C1)*SUN(A2:C2)=11*(A2+B2)*2=11*142=1562)
Copyright © 2024 SCHOLAR.TIPS - All rights reserved.
Answers & Comments
№1
76 (C1=A1+B1=A1+A1*3+12=4*A1+12=76)
№2
107 (=A2+B2)
180 (=A3+B3)
№3
160 (=С1+B1=A1+B1+B1)
159 (=С2+B2=A2+B2+B2)
246 (=С3+B3=A3+B3+B3)
№4
230 (=$A$1+B1)
260 (=$A$1+B2)
265 (=$A$1+B3)
№5
1562 (=D2*D1=MIN(A1:C1)*SUN(A2:C2)=11*(A2+B2)*2=11*142=1562)