Percentage Calculation

  User-DACAA4B6-2071-4134-8A1E49BBB8414030 07:45 11 Sep 2004
Locked

What is the formula on Excel to work out a %.
e.g. I want to know what % is 26 out of 42

Thanks
Herbyd

  rawprawn 08:00 11 Sep 2004

26/42% if 26 is A1 and 42 is A2 the formula is(A1/A2%)

Thank you , how do I do it if I want to want to make 2 cells equal 26?

  rawprawn 08:11 11 Sep 2004

Sorry, I don't know what you mean.

I want to add togetyer A2 and A3 and have them as a % of A1. I also didn't get the first formula to work
Thanks

  VoG II 08:24 11 Sep 2004

=100*(A2+A3)/A1

Thanks for your help .....it works

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Adobe shows still-in-development tools, including automatically colourising black-and-white photos

iPhone X news: Release date, price, new features & specs

Comment transformer un iPhone en borne Wi-Fi ?