How to Calculate Percentage in Google Sheets | Scribe

    How to Calculate Percentage in Google Sheets

    • Alejandra Arciniegas |
    • 6 steps |
    • 23 seconds
    • Google SheetsGoogle Sheets
    1
    Calculating a percentage in Google Sheets it's pretty simple and straightforward. Let's see how to do it. Start by navigating to you spreadsheet.
    2
    Once you open you spreadsheet document, click on the cell where you want to calculate the percentage.
    information ordinal icon
    Tip! The general formula used to calculate percentages is: - (Part/total)\*100 So in this case we would apply the same logic to the formula we are about to use in the spreadsheet.
    3
    Type "=("
    4
    Select the cell which contains the part that you want to calculate in the percentage, followed by the "/" symbol, to indicate a division operation.
    5
    Now, select the cell that contains the total for the calculation, close the bracket and follow it by adding "\*100", to indicate the multiplication.
    6
    Then, hit "enter" and that's all!