Next: 4. Week Four Up: 3. Week Three Previous: 3.2 Calc and Excel Contents
if function is a very powerful function because it gives a
spreadsheet the ability to make decisions. Nonetheless, this ability to
specify logic is still fairly limited.
For those who want to implement more complex logic integrated to a spreadsheet, Visual Basic should be considered. All Microsoft Office products, including Excel, has an interface to utilize Visual Basic to specify programming logic. Visual Basic, for all practical reasons, is a general purpose programming language. You can write programs to handle extremely complex logic.
It is out of the scope of this class to discuss the use of Visual Basic in Excel. Those who are interested in pursuing this should take CISP370 to learn more about Visual Basic.
For OpenOffice Calc, the equivalent programming language is OpenOffice
Basic. From what I can review, OpenOffice Basic is fairly similar to
Visual Basic.