M
Morgan
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))
=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))