Ask Your Question
0

How do I round off a concatenate value

asked 2018-08-18 03:00:11 +0200

_dave gravatar image

updated 2018-08-18 03:03:28 +0200

I have typed in the following: =CONCATENATE(G37-D37," just about match.") I get the following back - 13.7166666666667 just about match

My question is, how do I round it off to 13.7? I tried format cell - Number with 1 decimal places, this did not work.

The value in cell G37 is 39.47 and D37 is 25.75. And just to let you know the "about match" value was 14.25 Any suggestion is helpful and thanks ahead.

_dave

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2018-08-18 04:08:05 +0200

Ratslinger gravatar image

Hello,

Try

=CONCATENATE(ROUND(G37-D37;1);" just about match.")
edit flag offensive delete link more

Comments

Also note ROUNDUP and ROUNDDOWN are available.

Ratslinger gravatar imageRatslinger ( 2018-08-18 04:18:43 +0200 )edit

Thanks Ralslinger. That does the trick.

_dave gravatar image_dave ( 2018-08-18 04:27:05 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-08-18 03:00:11 +0200

Seen: 57 times

Last updated: Aug 18 '18