Column R18 uses the formula =IFERROR(IF(D18<$H$3,"Failed",""),"")
D = current price
$H$3 is the price I am comparing D18 to. $H$3 is constant, of course
Once the price in Column D becomes LESS THAN the fixed price of $H$3, the cell in R18 says "FAILED." That's great. But when I copy the...