Hansel,

Change the AVERAGE(H101:H102) to ROUND(AVERAGE(H101:H102),2) to meet the
last requirement.

HTH,
Bernie
MS Excel MVP



"Biff" wrote in message
...
Hi!

Try this:

=IF(OR(H101="",H102=""),"",IF(COUNTIF(H101:H102,"N/A")=2,"N/A",IF(COUNT(H101:H102)=1,MAX(H101:H102),IF(H101=H1 02,H101,AVERAGE(H101:H102)))))

Format as NUMBER 2 decimal places.

Biff