Finding the MAX value over a range but if one row is blank, the value for MAX must be blank
I suggest the following formula, assuming that the "Actual" column is C:
=IF(COUNTBLANK(C2:C8)=0,MAX(C2:C8),"")
Or more general:
=IF(COUNTBLANK(range)=0,MAX(range),"")