excel calculation

BJS | 13:38 Tue 06th Mar 2007 | How it Works

2 Answers

Subscribe
Report ⚑

How can I create a cell formula to work what PERCENTAGE a number is of another value to save using a calculator each time.
i.e say what percentage is 125 of 500 which we know to be 25%
Thanks for any help

wood burning stove

gasy

Answers

1 to 2 of 2

Best Answer

No best answer has yet been selected by BJS. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.

ACB312

Try this:- put your value (125) in say B1, other value (500) in B2. In the cell you want your answer type =B1/B2. Go to format, cell, number and click on percetage. Cheers, Andy

ACB312

Oops, that should have been - percentage.

1 to 2 of 2

Do you know the answer?