Rounding problem

[Szivecske]

If I have numbers under 10, then I want to rounding to 1. If above 10, then should rounding 0. How can I solve this in excel?

So an example:

12
16
18

Average
15 and not 15,3

6
7
6
Average
6,3 and not 6

 

[AliGW]

Assuming the number to be rounded is in cell A1:

=IF(A1<10,ROUND(A1,1),ROUND(A1,0))

 

[sashi nair]

Maybe this is what you wanted. =IF(AVERAGE(E6:E8)>9,ROUND(AVERAGE(E6:E8),0),ROUND(AVERAGE(E6:E8),1))

 

[FormR]

Here's another possible option:

=ROUND(AVERAGE(A1:A3),AVERAGE(A1:A3)<10)

Or as you are probably using European regional settings:

=ROUND(AVERAGE(A1:A3);AVERAGE(A1:A3)<10)