Home/ Questions/Q 9616
Next
Answered
computing
  • 0
Asked: 2021-12-02T12:15:49+00:00 In:

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. Best Answer
      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