Concat and decimal reduction

Jayzon

New Member
Joined
Feb 17, 2013
Messages
9
Hi All

I have a simple sheet formula that looks like this. =CONCAT(J2+G2+D2/A2*100;" %")

Value in J2=0

Value in G2=3

Value in D2=1

Values in A2=52

The result ends up being 4,92307692307692% which is way to many decimals no matter what i try i cannot get it down 4,92 without an error.

Hope someone can help.

Thank you in advance.
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,626
Office Version
365
Platform
Windows
How about
=CONCAT(ROUND(J2+G2+D2/A2*100,2)," %")

But not sure why you don't just format the cell as Percentage, rather than turning it into text
 

JimM

Well-known Member
Joined
Nov 11, 2003
Messages
644
Obviously I don't know what the formula is doing but are you sure that's the result you want, in effect it's

(D2/A2*100) + J2 + G2

I suspect you may be wanting

(J2+G2+D2)/A2*100
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,626
Office Version
365
Platform
Windows
Not for me it doesn't

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style="text-align: right;;">52</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">1</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;">0</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">4.92 %</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">H4</th><td style="text-align:left">=CONCAT(<font color="Blue">ROUND(<font color="Red">J2+G2+D2/A2*100,2</font>)," %"</font>)</td></tr></tbody></table></td></tr></table><br />

What error do you get?
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,318
or =FIXED(J2+G2+D2/A2*100)&" %"
 
Last edited:

Jayzon

New Member
Joined
Feb 17, 2013
Messages
9
I got a to few arguments error.

Not for me it doesn't

ABCDEFGHIJ
252130
3
44.92 %

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet2

Worksheet Formulas
CellFormula
H4=CONCAT(ROUND(J2+G2+D2/A2*100,2)," %")

<thead>
</thead><tbody>
</tbody>

<tbody>
</tbody>



What error do you get?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,027
Messages
5,466,114
Members
406,466
Latest member
mimi_b

This Week's Hot Topics

Top