formula help

[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

 

[Gord Dibben]

Check out the responses to your other posting.


Gord Dibben MS Excel MVP

 

[Pete_UK]

As a percentage of Sales:

=E7/B7

format cell as percentage, then copy down.

Hope this helps.

Pete