Formula to calculate reverse percentage

Does anyone know what the formula to calculate a reverse percentage in excel is?  

Example:  $57,900 is 80% of what number?  The answer should be $72,400 (rounded) but I don't know how to put in a formula to calculate that.

Does anyone know?  I need to do a whole list of numbers.

Thanks so much for any suggestions!

Answer
Answer
Let's say 57900 is in A2 and 80% in B2.

Use following formula to calculate = A2/B2

If you want rounded figure of 72400

=MROUND(A2/B2,100)
Sincerely yours,
Vijay A. Verma @ https://excelbianalytics.com

8 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 14, 2024 Views 12,176 Applies to: