Hi there,

Basicly I am trying to combine to formulas in the same cell and have both results in % but I need a bit of help....example


3.95 (cell1) 0.58 (cell2) 1.26 (cell3) Cell 4(should be showing the GP%)

Thats the formula what I am using but it shows in decimals and not percentage:

=1-ROUND(G143/I143,3) & "%-" & 1-ROUND(E143/12.75,3)& "%"

Many thanks

Try:

=CONCATENATE(TEXT(1-ROUND(G146/I143,3),"0.00%")," - ",TEXT(1-ROUND(E143/12.75,3),"0.00%"))

Thanks, it works perfect, now I will try to understand the formula :-)