Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
This is what i have & works but need to do more
AO6:AO66 = Names from week 1 =IF(AW60,AW6,'Week 1'!S6) AQ6:AQ66 = week 1 hours & adjusted hours =IF(AO6"",E6+AZ6,"") AR6:AR66 =L means laidoff=IF(AY60,AY6,"") AS6:AS66 = Average hours {=IF(OR(AR6="L",AW6""),AVERAGE(IF(AT$6:AT$66=0,A T$6:AT$66)),"")} AT6:AT66 = total hours of this week =IF(AR6="L","",AU6) AU6:AU66 = Total hours of week 1 & this week=IF(AR6="L",AS6,IF(B6="","",AQ6+SUM(F6:Q6)*1.5 +R6*2+S6*2)) AW6:AW66 = NAMES TO BE ADDED OR CHANGED AY6:AY66 = L if name is laid off AZ6:AZ66 = adjust hours if needed What i need is to: If AW6:AW66 "" this means names added or changed. Have average put in AU6:AU66 some how added to what i used above for AU column |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Desperately need help | Excel Worksheet Functions | |||
Desperately in need of some help | New Users to Excel | |||
DESPERATELY NEED HELP | Excel Discussion (Misc queries) | |||
Desperately need help!! | New Users to Excel | |||
Desperately need help with 3 calculations | Excel Worksheet Functions |