ocallaghan86
New Member
- Joined
- Dec 16, 2016
- Messages
- 2
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!
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!