Designing an Excel VBA Function to Recognize More Important Irrational Numbers

Abstract

During calculations, we often get an irrational value, the display of which is shown as a decimal fraction on the display of our calculator or computer. However, the value is difficult to interpret and inaccurate. Therefore, we created an Excel function so that numbers based on a major irrational value, such as irrational numbers resulting from the root of an integer or the number of Pi multiplied by a rational fraction, can be represented by the characters ”√” (root) or ”π” (Pi). The algorithms developed during programming were developed using the Visual Basic for Applications feature of the Microsoft Excel spreadsheet program. To display the number properly, our function must recognize the number obtained as an argument, which it displays in text format in a shorter and more interpretable form than the original, decimal fractional irrational number.