Rounding in CONCATENATE

[ToreiCZ]

Hello,

I can´t solve the issue with CONCATENATE and rounding in this function like this screen: https://ctrlv.cz/oEeL.
I need to round it only to 2 numbers after the decimal point (examlpe: 7.13%, not 7.15615615686164489%)
Can anyone help me with this function to solve it?

PS: Function is: =CONCATENATE(VLOOKUP(G3;A1:E24;4;0);" / ";VLOOKUP(G3;A1:E24;5;0);" = ";SUM(VLOOKUP(G3;A1:E24;4;0)/(VLOOKUP(G3;A1:E24;5;0))*100);"%"), screen ( https://ctrlv.cz/oEeL)


Thank you.
Regards,
ToreiCZ

 

[ToreiCZ]

*Forgot to type, I´m using Excel on iOS.

 

[jasonb75]

You just need to round the SUM before concatenating

=CONCATENATE(VLOOKUP(G3;A1:E24;4;0);" / ";VLOOKUP(G3;A1:E24;5;0);" = ";ROUND(SUM(VLOOKUP(G3;A1:E24;4;0)/(VLOOKUP(G3;A1:E24;5;0))*100);2);"%")

 

[ToreiCZ]

You just need to round the SUM before concatenating

=CONCATENATE(VLOOKUP(G3;A1:E24;4;0);" / ";VLOOKUP(G3;A1:E24;5;0);" = ";ROUND(SUM(VLOOKUP(G3;A1:E24;4;0)/(VLOOKUP(G3;A1:E24;5;0))*100);2);"%")

I tried it but without 2 on end, tried with zeros, **** i was so close

Thank you so much anyway

 

[Phuoc]

Or try:

=CONCATENATE(VLOOKUP(G3;A1:E24;4;0);" / ";VLOOKUP(G3;A1:E24;5;0);" = ";
TEXT(VLOOKUP(G3;A1:E24;4;0)/VLOOKUP(G3;A1:E24;5;0);"0.00%")