How to convert fraction to decimal... alternate way - Excel Tips and Tricks
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
• How to convert fraction to decimal - ...
#tips #excel #shorts #fyp
