Donate SIGN UP
Home > How it Works > excel calculation

excel calculation

Avatar Image
BJS | 12:38 Tue 06th Mar 2007 | How it Works
2 Answers
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
prev wood burning stove
  
next gasy
Gravatar

Answers

1 to 2 of 2rss feed

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.
Avatar Image 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
13:00 Tue 06th Mar 2007
Avatar Image ACB312
Oops, that should have been - percentage.
13:32 Tue 06th Mar 2007

1 to 2 of 2rss feed

Do you know the answer?

excel calculation

Answer Question >>