Cbrine said:This formula should work. You need to use Ctrl-Shift-Enter to enter the formula
=MAX(IF(ISERROR(C2:C6),0,C2:C6))
firefytr said:is there a significant gain using IsNumber instead of IsError?
firefytr said:is there a significant gain using IsNumber instead of IsError?