formula help
 

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

formula help
 

Check out the responses to your other posting.


Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 10:58:00 -0700, utpal
wrote:

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

formula help
 

As a percentage of Sales:

=E7/B7

format cell as percentage, then copy down.

Hope this helps.

Pete

On Sep 30, 6:58 pm, utpal wrote:
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