Skip to playerSkip to main content
We will explore how to convert fractions to decimal using CHOOSECOLS() instead of INDEX() function.

This is the formula featured in my video.

=CHOOSECOLS(TEXTSPLIT(B5,"/"),1)/CHOOSECOLS(TEXTSPLIT(B5,"/"),2)

Here is the breakdown of the formula.

The formula =CHOOSECOLS(TEXTSPLIT(B5,"/"),1)/CHOOSECOLS(TEXTSPLIT(B5,"/"),2) is used to split the contents of cell B5 by a delimiter (/), then select specific parts of the split content to perform a division. Here's a breakdown of how it works:

TEXTSPLIT(B5,"/"):

This function splits the text in cell B5 into separate components based on the delimiter /. For example, if B5 contains 12/4, TEXTSPLIT(B5,"/") would result in an array {12, 4}.
CHOOSECOLS(TEXTSPLIT(B5,"/"),1):

This function selects the first column (or the first element) from the array generated by TEXTSPLIT. In the example above, it would select 12.
CHOOSECOLS(TEXTSPLIT(B5,"/"),2):

Similarly, this function selects the second column (or the second element) from the array generated by TEXTSPLIT. In the example above, it would select 4.
Division:

The formula then divides the first element (12) by the second element (4), resulting in 3.


🔗🔗 LINKS TO SIMILIAR VIDEOS 🔗🔗
How to convert fraction to decimal - Excel Tips and Tricks
https://youtube.com/shorts/4Be3hszt_pY


How do I convert a fraction into decimal?,How do I convert Excel to decimals?,How do you transpose a fraction to a decimal?,How do I convert a fraction to a whole number in Excel?,

Check out my complete suite of Microsoft Excel Tips and Tricks.
https://www.youtube.com/@jjnet247/shorts
https://www.tiktok.com/@exceltips247
https://www.instagram.com/exceltips247/
https://www.dailymotion.com/ExcelTips247
https://www.pinterest.com/ExcelTips247/excel-tips-and-tricks/
https://x.com/ExcelTips247/media
https://www.reddit.com/r/Excel247/
https://www.facebook.com/XyberneticsInc/reels/

#microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypã‚· #exceltips #exceltricks
Transcript
00:00This is another way of converting fraction to decimal. In my previous video, I demonstrated
00:04how we can use index and text split function to convert fraction to decimal. In this episode,
00:10we will show you how we can do the same thing using choose column functions. Like before,
00:15we will use text split function to separate numerator and denominator with forward slash
00:19being the delimiter. To get only the numerator, we encapsulate text split function with choose
00:24call function and we get column number one as the second argument. We use the same technique to get
00:30the denominator assigning the second argument as number two. Now to convert from fraction to decimal,
00:35all we have to do is to divide the numerator with the denominator and voila, there you go.
00:40After that, apply the same formula to the rest of rows and job done.

Recommended