Microsoft Excel - Formula returning a figure range in 1 cell e.g. cell to reflect 50-70

Hi All,

Hoping someone can help.

I have a cell (A1) populated with the figure "100".

I want cell (A2) to return the figure of 50%-70% of cell (A1), being 50-70.

Is there a formula that can return this figure for me?

Thanks in advance for your help.

Cheers,

Torey

Hello Torey,
You could try:

=A1*0.5&" - "&A1*0.7

Regards
Harry

You're a champ! Works a treat - thanks Harry! :)