computing
  • 0

Example Of How Algorithms Is Used In Excel

  • 0

I would like to see how algorithms are applied and used in an excel spreadsheet. I would like to see a simple example if possible.

Share

1 Answer

  1. I still don’t know know what you mean by “apply the algorithms to a spreadsheet”.

    What do you mean by “the algorithms”?

    Are you asking how to enter a formula in a cell? e.g.

    =SUM(A1:A5)
    =VLOOKUP(A1,$B$1:$D$5,3,0)
    =IF(A1>0, “Yes”, “No”)

    Are you asking how to use VBA (a macro)? e.g.

    Sub SumAccount()
    'Sum Range and Format Cells
    On Error GoTo done
     Set MyRange = Application.InputBox("Select Cells To Sum", Type:=8)
        With ActiveCell
          .Formula = "=sum(" & MyRange.Address & ")"
          .Font.Size = 8
          .Font.Bold = False
          .NumberFormat = "#,##0"
          .HorizontalAlignment = xlRight
       End With
    done:
    End Sub

    Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

    • 0