Dec 05 2020 11:45 AM
Hi everyone,
I'm processing some data on excell.
I have 2 874x12 (rows x columns) tables of the same samples, and i want to add the values from table 2 of the same sample to table 1 with one simbol between the values.
Both tables have the values in this fromat "1.346172908" and i used the function (decrease decimal places) to present like this "1.3".
The final cell format that i want is "1.3 + 0.9".
Being "1.3" the value from table 1, "0.9" from table 2 and add the "+" simbol.
Can you help me? I'm struck in this because i don't know how to do it in few steps, otherwise i will do it cell to cell... and spend several hours.
Dec 05 2020 11:56 AM
Dec 05 2020 03:53 PM
Thank you for the answer! It works well, but when i do that i can't use the function to reduce decimal places. I get the two values and the simbol, but with long numbers. You know why?
Dec 05 2020 04:11 PM - edited Dec 05 2020 04:12 PM
SolutionIt's because you need to define a cut-off point for the decimals. Your adjusted formula would be:
=ROUND(P6,1)&" + "&ROUND(AJ3,1)
Dec 06 2020 09:46 AM
Another option is to use TEXT function - Office Support (microsoft.com) , with it you may apply any desired format to numbers.
Dec 06 2020 10:23 AM
Once you use the & operator, you change it to text.
So, If you still want to do any calculation on it, do it within the formula as Adversi mentioned
Dec 06 2020 10:24 AM
@adversi Thanks!!! I works well and it's exactly what i want!!!
Dec 06 2020 01:21 PM
Hi there,
Please round Function before each Cell Address:
=ROUND(B2,2)&"+"&ROUND(C2,2)
Please also note attached file .
I hope it will help you.
Dec 05 2020 04:11 PM - edited Dec 05 2020 04:12 PM
SolutionIt's because you need to define a cut-off point for the decimals. Your adjusted formula would be:
=ROUND(P6,1)&" + "&ROUND(AJ3,1)