Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mixed text and formula results
I need to track the hours of part time employees to ensure that the average
number hours per week they work does not exceed 18. Calculating the average is easy enough but I would like the cell to display how many hours over the average they have worked. For example, if the employee worked 37 hours in two weeks the cell should say €śExceeded allotted hours by 1.00€ť. The formula so far is =IF(AVERAGE(B3:B16)18,"exceeds allowable hours by", AVERAGE(B3:B16)) Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mixed text and formula results
The concatenate operator (&) is used to append a formula, so:
=IF(AVERAGE(B3:B16)18,"Exceeds allowable hours by "&AVERAGE(B3:B16)-18,AVERAGE(B3:B16)) On Jun 24, 2:57*pm, johnu wrote: I need to track the hours of part time employees to ensure that the average number hours per week they work does not exceed 18. *Calculating the average is easy enough but I would like the cell to display how many hours over the average they have worked. *For example, if the employee worked 37 hours in two weeks the cell should say “Exceeded allotted hours by 1.00”. *The formula so far is =IF(AVERAGE(B3:B16)18,"exceeds allowable hours by", AVERAGE(B3:B16)) Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
mixed text and formula results
=IF(AVERAGE(B3:B16)18,
"Exceeds allowable hours by"&TEXT(AVERAGE(B3:B16)-18,"0.00"), AVERAGE(B3:B16)) -- __________________________________ HTH Bob "johnu" wrote in message ... I need to track the hours of part time employees to ensure that the average number hours per week they work does not exceed 18. Calculating the average is easy enough but I would like the cell to display how many hours over the average they have worked. For example, if the employee worked 37 hours in two weeks the cell should say "Exceeded allotted hours by 1.00". The formula so far is =IF(AVERAGE(B3:B16)18,"exceeds allowable hours by", AVERAGE(B3:B16)) Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mixed text and formula results | Excel Discussion (Misc queries) | |||
formula mixed text and values | Excel Discussion (Misc queries) | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
Incrementing Mixed text & numbers | Excel Discussion (Misc queries) | |||
Stripping mixed number and text | Excel Worksheet Functions |