excel
how do i form a ratio. is there a formula?
|
excel
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. "Jeanie" wrote: how do i form a ratio. is there a formula? |
excel
Make sure you have the Anaysis Toolpak Add-in installed
=A1/GCD(A1,B1)&":"&B1/GCD(A1,B1) "Miguel Zapico" wrote: 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. "Jeanie" wrote: how do i form a ratio. is there a formula? |
All times are GMT +1. The time now is 01:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com