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

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 |