Biff,

Formatting only affects display and not the actual number, so any subsequent
calculations would be affected.

The OP explicitly requested rounding to two decimal places only if the
numbers were different.

1) If both cells H101 and H102 have numbers that are the SAME I want
the number pulled out and NOT rounded
2) If both cells are N/A I want the N/A pulled out.
3) If one cell is N/A and the other is a number, I want the number
pulled out and NOT rounded
4) If both cells are numbers AND they are DIFFERENT I want them
AVERAGED and then ROUNDED

Bernie


"Biff" wrote in message
...
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