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
Watch video How to convert fraction to decimal... alternate way - Excel Tips and Tricks online without registration, duration hours minute second in high quality. This video was added by user Rabi Gurung 20 August 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 798 once and liked it 14 people.