LET function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/let-function/ Bestselling Excel and Power BI Courses Wed, 12 Jun 2024 08:00:44 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png LET function Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/let-function/ 32 32 How to Calculate Ratios in Excel https://www.xelplus.com/excel-calculate-ratios/ Thu, 25 Mar 2021 10:00:00 +0000 https://www.xelplus.com/?p=10178 Easily calculate the ratio of two numbers in Excel with Excel formulas. Ratios are a common way to compare amounts. To calculate ratios, you need to calculate the highest common factor. You can easily do this with the GCD function.

The post How to Calculate Ratios in Excel appeared first on Xelplus - Leila Gharani.

]]> How to Use the Excel LET Function https://www.xelplus.com/excel-let-function/ Thu, 13 Aug 2020 09:00:00 +0000 https://www.xelplus.com/?p=10815 The new Excel LET function can make your formulas easier to read. PLUS it can improve the performance of your formulas so they run faster. Should you use this function in your files? Find out more in the complete tutorial.

The post How to Use the Excel LET Function appeared first on Xelplus - Leila Gharani.

]]> Excel VBA Data types, DIM & SET (Learn to use them correctly) https://www.xelplus.com/excel-vba-data-types-dim-set/ Sun, 20 Jan 2019 02:21:00 +0000 https://www.xelplus.com/?p=13017 If you like to create efficient Excel macros, it's important to assign the correct data type to each variable. In this tutorial find out why you need to use the DIM statement and when you should use SET instead.

The post Excel VBA Data types, DIM & SET (Learn to use them correctly) appeared first on Xelplus - Leila Gharani.

]]>