Another Excel question

  pj123 17:38 30 Apr 04

I am not very good at maths so I need a formula to find "what percentage 70 is of 200" I know it is 35 doing it in my head. I also know that the percentage 125 of 250 is 50. But I need a formula that will work it out from whatever 2 sets of numbers are entered. eg. what percentage 90 is of 200. Again in my head I know it is 45 but I can't work out a formula that gives the correct answer regardless of what figures are entered.

  Nosmas 18:00 30 Apr 04

The formula is n x 100/v = p where n = the number you wish to express as a percentage of another; v = the value of which n is a percentage; and p = the result of the calculation i.e. the percentage that n is to v

In your examples 70 x 100/200 = 35 (%)

and 125 x 100/250 = 50 (%)

With decimals (instead of integers)

25.5 x 100/63.75 = 40 (%) (i.e. 25.5 is 40% of 63.75)

Hope this helps

  pj123 18:52 30 Apr 04

Thanks Nosmas, that looks good to me. The bit I missed was the constant (100). Will give it a try and post back.

  pj123 19:31 30 Apr 04

Nosmas. Worked like a dream. Thanks a lot. Now ticked.

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

Battlefield 1 review: Destructive environments, phenomenal graphics and an emotional campaign make…

1995-2015: How technology has changed the world in 20 years

Microsoft HoloLens hands-on review

How to use System Preferences in macOS Sierra (and Mac OS X): Complete guide to personalising the…