In the screen shot below, you can see the 4 formulas that it suggested, and the results of those formulas. Please write 4 formula examples to calculate a ratio in Excel, showing the ratio in a:b format.Next, I tried one of the AI writing tools, which shall also remain nameless. calculate the ratio between numbers in cells B4 and C4Īnd here’s the formula – a simple division:.

Get the ratio between numbers in cells B4 and C4 in x:y format, reduced to lowest termsĪnd here’s the suggested formula for that:ģ) And here’s my final prompt, in case the bot was confused by my “x:y” format request:.

But…we usually want the smallest numbers possible, in the ratio results.Ģ) Next, I entered another prompt, with more details on the result that I wanted: Well, that was technically correct, I guess.

Get the ratio between numbers in cells B4 and C4 in x:y format.

To use this formula helper, I had to sign up, using my email, but there is a free plan, and that gives you a few uses per month.įirst, you enter a text description of the problem that you’re trying to solve, and then the AI tool suggests a formula.ġ) This was my first prompt, asking for help: (I’ll leave the tool’s name out of this story.) There are a few Excel formula helper bots now, so I tried one of those next. So I clicked that link, and the tutorial didn’t mention ratio, but it did show how to calculate percentage by dividing. The closest was the fifth link, Calculate percentages. When I searched for “ratio formula”, there were five links in the results, and none of them mentioned ratio. Yesterday, just for fun, I tried to find help on how to write an Excel ratio formula, posing as someone who had no idea how to do that.įirst, I used Excel’s built-in help, and it didn’t look too helpful. NOTE: There’s a longer Ratio video at the end of this page, with a GCD function example too. The formula is created in 3 steps, using division first, then the formatting that result with the TEXT function, and finally, adding the SUBSTITUTE function. The result shows the ratio between two numbers, in x:y format. In this 2-minute video, see how to create a ratio formula in Excel. And no, Excel doesn’t have a RATIO function, even though one overly-confident AI helper tool said it does!

In my latest video, I show a quick Excel formula for the ratio between two numbers, in x:y format. Do you ever use Excel to calculate a ratio? In business, you could compare income to expenses, and at home, you could use ratios to bake a cake, without a recipe.

Enspire formula samples