formula help

U

utpal

what is the Labor % in g7

5 a b c d e
f g
6 Date Sales Emp Work Hours Labor Cost Day
Labor %
7 1/1/2007 1001.51 3 14.34 102.531 Mon
?
8 1/2/2007 859.52 4 18.58 132.847 Tue
?

Thank You
Utpal
 
P

Pete_UK

As a percentage of Sales:

=E7/B7

format cell as percentage, then copy down.

Hope this helps.

Pete
 
Top