Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|