Example of how Algorithms is used in Excel

February 21, 2012 at 12:52:29
Specs: Windows XP
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.

See More: Example of how Algorithms is used in Excel

Report •

#1
February 21, 2012 at 14:55:26
I don't understand your question.

An algorithm is defined as:

"A formula or set of steps for solving a particular problem. To be an algorithm, a set of rules must be unambiguous and have a clear stopping point."

What do you mean by seeing "how algorithms are applied and used in an excel spreadsheet"?

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


Report •

#2
February 22, 2012 at 06:06:56
I was asked to apply the algorithms to a spreadsheet. I think the incorrect terminology was used.

Report •

#3
February 22, 2012 at 07:16:11
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.


Report •
Related Solutions


Ask Question