Mughees Siddiqui’s Blog

Mughees Siddiqui’s personal blog

Excel formula to calculate Ratios

=(LEFT(TEXT(A1/B1,”####/####”),FIND(”/”,TEXT(A1/B1,”####/####”))-1)&”:”
&RIGHT(TEXT(A1/B1,”####/####”),LEN(TEXT(A1/B1,”####/####”))
-FIND(”/”,TEXT(A1/B1,”####/####”))))

Written by mughees

December 19th, 2008 at 8:31 am

Posted in Microsoft Office

« inteGREAT Studio Demo
Difference between QA and QC »