Construct a formula to display '50 - 60%' of a source cell

[Northumbrian]

Newbie alert here... I've looked around but can't seem to find an answer to my specific need. Which is this:

Suppose cell A2 contains a whole number that I've entered. I need cell B2 to calculate (and display) a range equal to say 50% - 60% of that number.

So if I enter 180 in A2, then I want B2 to display '90 - 108 ' (with spaces and dash!)

I then need only change A2 to have new results calculated and displayed in B2.

What formula would yield this result, please? Once I have the syntax I'll be able to edit it in order to deploy in multiple cells around my workbook.

Thanks for being here to help!

[Fluff13]

How about

Please Login or Register  to view this content.

[Pete_UK]

Welcome to the forum.

You can use this formula in B2:

=IF(A2="","",TEXT(A2/2,"0 - ")&TEXT(A2*6/10,"0"))

Hope this helps.

Pete

[Northumbrian]

Thanks very much guys, for your helpful solutions here. I've settled on Fluff13's simpler option for now
I've proved it works well for me - but in the process, have discovered something I can't solve, and I hope you can help please.
I'm using variations on this formula to calculate other percentage ranges, eg a range from 71-80%. That yields a result which isn't a whole number - which is what I need. I've tried formatting the result-cell to display as Number to 0 decimal places, but the result of the formula continues to display as eg 109.8. How can I get the result of the formula to round up (or down) please?
Thanks again for your help here.

[Fluff13]

How about

Please Login or Register  to view this content.

[Pete_UK]

If you had used my formula you would find that it only returns integer values.

Hope this helps.

Pete

[Northumbrian]

I knew that...
Thanks very much again to both of you - it's great that there's such willingness to help out those of us less accomplished.
Much appreciated.

[Fluff13]

Glad to help & thanks for the feedback

[Northumbrian]

Thanks again Pete. I was attracted to the simpler version mainly because it was easier to change my percentages to values like 71%, 84% etc. Always more than one way to achieve our objectives though eh! Thanks.

[Pete_UK]

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

[Northumbrian]

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

And thanks also for this extra advice Pete. I'd already found the 'Add Reputation' star and deployed that for my two fantastic helpers, but I didn't easily find how to mark the question 'answered'. Will do that now! So - thanks again.
Really, this is the best of the internet...