((1&0)v1)&(1v0) = ((0)v1)&(1v0) = (0v1)&(1) = (1)&1 = 1&1 = 1
<h2>Пример (при A, B, C = 0)</h2>
- false && false || false = <u>false</u>
- false || (true || false) = false || true = <u>true</u>
- true || (false && false) = true || falce = <u>true</u>
- (false && false) || (false && false) = false || false = <u>false</u>
- (false || false) || (false || falce) = false || false = <u>false</u>
1) 5 => 8 => 16 => 19 => ответ 38
2)2 => 7 => 6 => 11=> 10 => 15 => 14 => ответ 42
3) 1=> 3 => 2 => 6=> 5 => 15 => ответ 14
4) 1=> 6 => 5 => 10 => 9 => 14 => 13 =>18 => ответ 17
Sub MyMid()
a = Range("B3:B14")
n = UBound(a, 1)
s = 0
For i = 1 To n
s = s + a(i, 1)
Next i
Range("E3").Value = s / n
End Sub
<em><u>Можно и короче записать:</u></em>
Sub MyMid2()
Range("E3") = Application.WorksheetFunction.Average(Range("B3:B14"))
End Sub