# Using ROUND

#### ocallaghan86

##### New Member
Hello All,

I'm trying to use ROUND to generate a result with a specific amount of decimal places (obviously). I'm also stringing the ROUND function into IF and CONCATENATE functions:

IF(X,(CONCATENATE(ROUND(AVERAGE(A:B),1),"*"),Z)

My issue is when my true result generates a 0 in the tenths place followed by a digit less than 5 (for example, 1.04), then the above IF string would generate 1 as opposed to 1.0.

However if my true value happens to be 1.05 or greater in the hundredths place, then it will generate 1.1.

I need my result to always generate that tenths place. Is there anything additional I need to include to generate that 0 in the tenths place? Or is there another function that would be better for that situation?

Thank you for any responses!

### Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
Welcome to the Board!

Use the TEXT function to return a specific format of that piece you are concatenating, i.e.
Code:
``[COLOR=#333333]IF(X,(CONCATENATE([/COLOR][COLOR=#ff0000]TEXT(ROUND(AVERAGE(A:B),1),"0.00")[/COLOR][COLOR=#333333],"*"),Z)[/COLOR]``

Last edited:
=IF(X,(CONCATENATE(FIXED(AVERAGE(A:B),1),"*"),Z)

This one should work for you. Instead of ROUND you would use FIXED which also rounds it.

Thanks Joe4 and austin397! Both of your replies worked great! And thanks for the welcome Joe4

Replies
0
Views
501
Replies
0
Views
418
Replies
3
Views
401
Replies
16
Views
890
Replies
2
Views
437

1,196,391
Messages
6,015,006
Members
441,865
Latest member
Enragedpanda

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back