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 use an example. Let's say the attacker strength is 10, and the defender strength is 40 (not a good idea attacking an enemy that is that strong). When I divide that out, it comes out to 4 (i.e., defender strength divided by attacker strength), but what I am looking for is a ratio. I want the cell output to actually say 1:4 (i.e., 10 to 40). Right now, I just have a simple formula of =sum(f2/f3), where f2 is the Defender Strength and f3 is the attacker strength. How can I tweak my formula so that the cell output is in a ratio?
