Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
incorporate the remove #DIV/0! code into another formula to get bl
hi there, i have this formula below, and i somehow want to incorporate this
=IFERROR(B1/C1,"") into it with the purpose of having the cell display nothing instead of #DIV/0! so that the column of data can then allow an index and match formula to work as it won't if any of the cells have #DIV/0! in them, any suggestion? =(SUMIF($B$2:$B$2500,"=" & T58,$M$2:$M$2500)-SUMIF($B$2:$B$2500,"=" & (T58+TIMEVALUE("1:00")),$M$2:$M$2500))/(SUMIF($B$2:$B$2500,"=" & T58,$D$2:$D$2500)-SUMIF($B$2:$B$2500,"=" & (T58+ TIMEVALUE("1:00")),$D$2:$D$2500)) -- thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorporate a condition in an IF((OR €¦.formula | Excel Discussion (Misc queries) | |||
How do I incorporate a formula to calculate many months releases? | Excel Worksheet Functions | |||
How do I incorporate letters as numbers in a formula? | Excel Discussion (Misc queries) | |||
IF formula help - incorporate greater than & smaller than | Excel Worksheet Functions | |||
Way to Incorporate Trim Into Match/Index Formula | Excel Worksheet Functions |