Originally Posted by wachinnai

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