Yearly Archives: 2020

Last Updated on January 11, 2023 by token 1. Asc VBA function – Description The Asc VBA function   returns the position of a character in an ASCII character array . For example, the letter “a” is position 97 in the ASCII code table. If we would like to get a […]

Last Updated on January 11, 2023 by token 1. Atn VBA function – Description The Atn VBA function   returns the arcustangent value. In order to calculate the arcustangent value, we should use this function. For example, arctan with 1 is Pi / 4. 2. VBA Atn function – Syntax 'officeinside.org […]

Last Updated on January 11, 2023 by token 1. Tan VBA Function – Description The Tan VBA function   returns the tangent value. In order to calculate the value of tngens, we should use this function. For example, the tangent of 0 is equal to 0. 2. VBA Tan function – […]

Last Updated on January 11, 2023 by token Cos VBA function – Description The Cos VBA function returns the cosine value. You should use this function to calculate the cosine value. For example, the cosine of 0 is equal to 1. VBA Cos function – Syntax 'officeinside.org Cos (Number As […]

Last Updated on January 11, 2023 by token Sin VBA function – Description The Sin VBA function returns the sine value. In order to calculate the sine value, you should use this function. For example, the sine of 0 is equal to 0. VBA Sin function – Syntax 'officeinside.org Sin […]

Last Updated on January 11, 2023 by token Sgn VBA function – Description The Sgn VBA function returns the sign of the number specified in the argument. The function determines the sign, so it checks whether the argument is a negative, positive, or eual to 0. In the case of […]

Last Updated on January 11, 2023 by token Sqr VBA function – Description The Sqr VBA function returns the square root of the argument in the Double data type. With this function you can calculate the root of the second square degree. To calculate the root of a greater degree […]

Last Updated on January 11, 2023 by token 1. Rnd VBA function – Description The Rnd VBA function returns a random number between 0 and 1. The function can be compared to the RAND function in an Excel sheet. We use this function to generate random numbers. The operation can be modified in any way to select a […]

Last Updated on January 11, 2023 by token Round VBA Function – Description The Round VBA function is used to round numbers with decimal places. How can we use the Round function? In place of the first argument of the function, enter the number you want to round. In place of the second argument, enter […]