Forum Discussion
Changing from division formula output to a Ratio
Ok. I am trying to set up an automated combat table for one of my favorite board war games. One of the first things I did was the simple attacker strength divided by the defender strength. I will ...
Ok. I did a little more digging, and I found this formula, =F2/GCD(F2,F3)&":"&F3/GCD(F2,F3). And that works. In my example above, that gives me a 1:4 ratio, which is right on.
mnmanstein Or just format the cell with the division as a Ratio.
Riny_van_Eekelen 10-4! That would be even easier. Thanks!!