Thread: formula help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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