declare four variables Dim i, term, N, stepSize As Integer Dim sumType As String Initialize variable which aku pon tak pasti i = 0 N = Range(C2).Value sumType = Range(C3).Value Empty field to calculate_entah ble compile ke tak Range(A8:B1000).Value = Range(C6).Value = Determination of product which have been calculate Select Case sumType Case Is = All stepSize = 1 Case Is = Odd stepSize = 2 Case Else MsgBox Enter a valid expression in cell C3 End End Select Do calculation For term = 1 To N Step stepSize Cells(8 + i, 1).Value = term Cells(8 + i, 2).Value = (term ^ 2 + (6 * term) + 1) / ((9 * term) + 7) Range(C6).Value = Range(C6).Value + Cells(8 + i, 2).Value i = i + 1 Next term =Then aku compile masih error...pls someone debug tuk aku!!!!!HELP....spreadsheet tak jadi lagi for complex number calculation
Posted on: Thu, 28 Aug 2014 07:15:15 +0000