Designing an Excel VBA function to recognize more important irrational numbers

Fabulya Zoltán: Designing an Excel VBA function to recognize more important irrational numbers. In: Analecta technica Szegedinensia, (16) 1. pp. 62-70. (2022)

[thumbnail of engineering_2022_001_062-070.pdf]
Preview
Cikk, tanulmány, mű
engineering_2022_001_062-070.pdf

Download (359kB) | Preview

Abstract

Calculations typically performed on a calculator or computer show the result as a decimal fraction if it is not an integer. It would be easier to interpret the result if a value could be expressed with integers and operations, such as the root subtraction operation. This article shows how this can be done with a developed algorithm in Microsoft Excel, which recognizes the most famous irrational numbers and displays them in text form together with the character of the operation sign. For example, “5√3/2” is given for 4.330127019. It is also useful to display irrational numbers with integers because only an infinite number of decimal places in a decimal fraction could show the exact value, and that is not possible. So, the developed algorithm can display a more interpretable and accurate form of the irrational number. In addition to the results that can be written as square roots, the algorithm is capable of displaying irrational numbers that can be expressed as the number Pi, using the π character. The Excel algorithm which was implemented in Visual Basic for Applications shows all rational numbers as the quotient of two integers that are relative primes.

Item Type: Article
Journal or Publication Title: Analecta technica Szegedinensia
Date: 2022
Volume: 16
Number: 1
ISSN: 2064-7964
Page Range: pp. 62-70
Language: English
Publisher: University of Szeged, Faculty of Engineering
Place of Publication: Szeged
Related URLs: https://acta.bibl.u-szeged.hu/77815/
DOI: 10.14232/analecta.2022.1.62-70
Uncontrolled Keywords: Táblázatkezelés - számítógép - programozás, Program - táblázatkezelő - Excel, Programozási nyelv - Visual Basic
Additional Information: Bibliogr.: p. 69-70. ; összefoglalás angol nyelven
Subjects: 01. Natural sciences
01. Natural sciences > 01.02. Computer and information sciences
Date Deposited: 2022. Dec. 14. 14:52
Last Modified: 2023. Jul. 13. 10:39
URI: http://acta.bibl.u-szeged.hu/id/eprint/77872

Actions (login required)

View Item View Item