Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Does anyone know how I would alter this using ROUND? Also, when cells in Col
H and/or Col E are blank I would like it if the cell that contained this formula didn't say #DID/O! but was just blank. Thanks. =INT(AVERAGE(IF((H13:H36={"in","ti"}),E13:E36))) This is what I'm trying to do..... Col E Col H 9/17/08 in 9/18/08 ti 9/19/08 ot When H13:H36 = in OR H13:H36 = ti, Then return the average date from E13:E36 when there is an average date but blank when cells in Col H & E are blank. Thanks in advance for any help. Christy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Average and Round together | Excel Worksheet Functions | |||
Return an average date | Excel Worksheet Functions | |||
How to return the average of the LAST 3 numbers in a row | Excel Worksheet Functions | |||
How do I round a number after finding the average? | Excel Worksheet Functions | |||
average annual return | Excel Worksheet Functions |