how do i form a ratio. is there a formula?
M Miguel Zapico May 25, 2006 #2 Would this do? In C1 type: =A1/B1 For a ratio of the content of the A1 cell over the B1 cell. Is that what you are looking for? Miguel.
Would this do? In C1 type: =A1/B1 For a ratio of the content of the A1 cell over the B1 cell. Is that what you are looking for? Miguel.
D Dave May 25, 2006 #3 Make sure you have the Anaysis Toolpak Add-in installed =A1/GCD(A1,B1)&":"&B1/GCD(A1,B1)
