ratio function
I have Labor Cost in H9 and Material Cost in I9 I want J9 to show them as a
ratio of 100. Such as $1,000 labor and $2,010 material would equal 33:67.... Please help!!! |
ratio function
Try this:
=H9/(H9+I9) Format as a percentage. Hope this helps. Pete On Jan 29, 5:25*pm, n_sevcik wrote: I have Labor Cost in H9 and Material Cost in I9 I want J9 to show them as a ratio of 100. Such as $1,000 labor and $2,010 material would equal 33:67..... * Please help!!! |
ratio function
"n_sevcik" wrote: I have Labor Cost in H9 and Material Cost in I9 I want J9 to show them as a ratio of 100. Such as $1,000 labor and $2,010 material would equal 33:67.... Please help!!! Hi , Pl put following formula in cell J9 =ROUND(100*H9/(H9+I9),0)&":"&100-ROUND(100*H9/(H9+I9),0) H S Shastri |
ratio function
=INT(H9/(H9+I9)*100) & ":" & 100-INT(H9/(H9+I9)*100)
HTH, Bernie MS Excel MVP "n_sevcik" wrote in message ... I have Labor Cost in H9 and Material Cost in I9 I want J9 to show them as a ratio of 100. Such as $1,000 labor and $2,010 material would equal 33:67.... Please help!!! |
ratio function
perhaps...
=ROUND(H9/SUM(H9:I9)*100,0)&":"&ROUND(I9/SUM(H9:I9)*100,0) HTHs |
ratio function
=TEXT(H9/(H9+I9)%,"0")&":"&TEXT(I9/(H9+I9)%,"0")
or if you can live with a slash "/" and if H9<=I9: =TEXT(H9/I9,"0/"&ROUND(I9/(H9+I9)%,0)) Regards, Bernd |
ratio function
Here is another one for you to consider...
=ROUND(100/(1+I13/H13),0)&":"&ROUND(100/(1+H13/I13),0) -- Rick (MVP - Excel) "n_sevcik" wrote in message ... I have Labor Cost in H9 and Material Cost in I9 I want J9 to show them as a ratio of 100. Such as $1,000 labor and $2,010 material would equal 33:67.... Please help!!! |
All times are GMT +1. The time now is 11:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com