How to convert fraction to decimal... for older Excels - Excel Tips and Tricks

We will show you how to convert fraction to decimal in older version of Excels.

Lets break this formula down.

=LEFT(B5,FIND("/",B5)-1)/RIGHT(B5,LEN(B5)-FIND("/",B5))

FIND("/", B5):

Purpose: Find the position of the "/" character in the string in cell B5.
Example: If B5 contains "1/10", FIND("/", B5) returns 2 because "/" is the second character.
LEFT(B5, FIND("/", B5) - 1):

Purpose: Extract the part of the string before the "/" character.
Example: LEFT("1/10", 2 - 1) extracts "1". The 2 - 1 is 1, so it takes the first character.
LEN(B5):

Purpose: Get the length of the string in cell B5.
Example: For "1/10", LEN(B5) returns 4.
LEN(B5) - FIND("/", B5):

Purpose: Calculate the length of the substring after the "/" character.
Example: 4 - 2 gives 2, so it takes the last 2 characters.
RIGHT(B5, LEN(B5) - FIND("/", B5)):

Purpose: Extract the part of the string after the "/" character.
Example: RIGHT("1/10", 2) extracts "10". It takes the last 2 characters.
LEFT(B5, FIND("/", B5) - 1) / RIGHT(B5, LEN(B5) - FIND("/", B5)):

Purpose: Divide the numerator (the part before "/") by the denominator (the part after "/").
Example: "1" (numerator) divided by "10" (denominator) results in 0.1.
So the formula takes a string fraction, splits it into numerator and denominator, and then performs the division to give the decimal result.

How to Convert Fractions to Decimals,What is 5 ⁄ 8 as a decimal?,What is 7/8 as a decimal?,How to convert fraction into number?,What is 2 ⁄ 5 as a decimal?,What is 4 ⁄ 5 as a decimal?,

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