|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.
=IF(A1>0, "Yes", "No")
Are you asking how to use VBA (a macro)? e.g.
'Sum Range and Format Cells
On Error GoTo done
Set MyRange = Application.InputBox("Select Cells To Sum", Type:=8)
.Formula = "=sum(" & MyRange.Address & ")"
.Font.Size = 8
.Font.Bold = False
.NumberFormat = "#,##0"
.HorizontalAlignment = xlRight
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.