+ Reply to Thread
Results 1 to 5 of 5

Calculate a percentage between two number

  1. #1
    Registered User
    Join Date
    04-13-2021
    Location
    Syria
    MS-Off Ver
    Microsoft Office Home and Student 2021
    Posts
    81

    Question Calculate a percentage between two number

    Hello,
    I tried a lot to get the percentage between two numbers but I didn't get the desired result.

    The result is that I have a 100ml bottle of perfume.
    If I put 20ml of alcohol, I want to know how much alcohol is in it:
    For example:
    If the volume of the bottle is 100 ml (in cell A1), And the alcohol in it is 20 (in cell b1), it should show me 20% (in cell c1)
    And if it has 100ml of alcohol it should show me 100%.
    And if the volume of the bottle is 1000 ml and the alcohol in it is 250 ml, then it should show me 25%... and so on..

    I hope my question is clear.. Thank you

  2. #2
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Calculate a percentage between two number

    Really?
    Into C1:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and format as percent.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  3. #3
    Registered User
    Join Date
    04-13-2021
    Location
    Syria
    MS-Off Ver
    Microsoft Office Home and Student 2021
    Posts
    81

    Re: Calculate a percentage between two number

    very simple ,
    I couldn't figure it out on my own, Thank you very much.

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: Calculate a percentage between two number

    Happy to help.
    EDIT: Please mark thread as SOLVED.
    Last edited by KOKOSEK; 04-08-2022 at 06:51 AM.

  5. #5
    Registered User
    Join Date
    04-13-2021
    Location
    Syria
    MS-Off Ver
    Microsoft Office Home and Student 2021
    Posts
    81

    Re: Calculate a percentage between two number

    Ok, sorry for late

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Cannot Calculate a Percentage Below or Above a Set Number
    By pjfoster in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-24-2014, 05:51 PM
  2. [SOLVED] Calculate number based on percentage
    By Manish Bajpai in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 09-06-2005, 06:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1