Во вложении - файл с рабочей книгой в формате MS Excel 2003.Макросы находятся в проекте первого листа.Sub Ex1() mn = 1000# For x = 0 To 6 Step 0.5 y = Log(x + 3.7) * Cos(x) If y < mn Then mn = y Next x Cells(1, 4) = mnEnd SubSub Ex2() Dim ay As Variant ay = Array(4, 0.1, 9, 5, 998) i = 5 s = 0# For x = -5 To 5 Step 0.8 For j = 0 To 4 y = ay(j): z = x ^ 3 + y ^ 2 If z > 0 Then z = Sqr(z) s = s + z Cells(i, 1) = x Cells(i, 2) = y Cells(i, 3) = z i = i + 1 Next j Next x Cells(4, 4) = sEnd Sub