Concatenate 2 values into % Format

[cogumelo]

Hi,

I have this formula, where i'm comparing 2 values but i want them to show in % format:

IFERROR(1-(V10-Z10)/(AA10/1,23);"")&" ("&IFERROR(1-(T10-Z10)/(AA10/1,23);"")&")"

instead of appearing like this:
0,192345 (0,231234)

i want them formatted like this:
19,23% (23,12%)

Tried to do it with TEXT Function but i'm not being able to do it.

Can anyone help out?

thx in advance
cogumelo

 

[Tim_Excel_]

That doesn't seem like a valid formula to me

Regardless, you could do something along the lines of

IFERROR((YOURFORMULA)*100 & "%","")

This simply multiply the output of the formula by 100 and add the percentage symbol

 

[cogumelo]

Thanks Tim for you quick help!

 

[cogumelo]

One more question, though, how do I limit the number of characters?

change it from 19,4762108872696% to 19,48%
thx in advance

 

[Tim_Excel_]

For this use LEFT(formula,5)*100&"%"

I wonder however, why don't you just change the cell's format to percentage?

 

[cogumelo]

Hi! Thx again.

I'm doing it because i need to put 3 different % values in the same cell coming from different calculations.