"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