Using ROUND

[ocallaghan86]

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!

 

[Joe4]

Welcome to the Board!

Use the TEXT function to return a specific format of that piece you are concatenating, i.e.

[COLOR=#333333]IF(X,(CONCATENATE([/COLOR][COLOR=#ff0000]TEXT(ROUND(AVERAGE(A:B),1),"0.00")[/COLOR][COLOR=#333333],"*"),Z)[/COLOR]

 

[austin397]

=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.

 

[ocallaghan86]

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