super quick excel formula needed

[uul]

Hi all i am trying to create the below statement in a text box. The cell refs are a1 for 89% and a2 for 69% - and i cannot create the formula to return the below statement.

89% v 69% last week

Any help would be appreciated.

 

[Sathish KV]

Hi,

Is this what you required

=A1*100&"%"&" v "&A2*100&"%"

 

[uul]

Hi thanks for reply, but its giving me a number with 10 decimal places, like 88.01234567 etc - just need it to return 89% and 69%

 

[Sathish KV]

Hi,

Could you upload a sample file

 

[NARAYANK991]

Hi ,

If A1 and A2 contain percentage values , then try this :

=TEXT(A1,"# %") & " v " & TEXT(A2, "# %") & " last week"

Narayan

 

[Khalid NGO]

Hi,

Addition to Sathish KV formula:
=A1*100&" %"&" v "&A2*100&" %"&" last week"

 

[uul]

Thankyou everyone for your help much appreciated - NARAYANK991 you have solved my % issue I was having with your formula as it was giving me over 10 decimal places when i was trying to link the cells.

Everyone thanks again, love this forum

 

[Hui]

or
=ROUND(A1*100,2) & "% v " & ROUND(A2*100,2) & "% last week"
Change Decimal places (,2) to how ever many decimal places you want