I only want to round numbers to the nearest hundreth

=ROUND(AVERAGE(10,15),2) = ???

I'm assuming they want 12.50 vs 12.5 that's why I used the number format.

Biff

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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