+ Reply to Thread
Results 1 to 5 of 5

Google Sheets - Help with formular to calculate percentage

  1. #1
    Registered User
    Join Date
    08-05-2022
    Location
    Spain
    MS-Off Ver
    365
    Posts
    5

    Google Sheets - Help with formular to calculate percentage

    Hi ,

    i have issues when trying to calculate the percentage of a given field. This is the formula i use but it throws an error:

    Please Login or Register  to view this content.

    Captura de Pantalla 2023-02-16 a las 12.01.50.png

    Any help would be appreciated. Thanks so much.

  2. #2
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,150

    Re: Google Sheets - Help with formular to calculate percentage

    Try this;

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-05-2022
    Location
    Spain
    MS-Off Ver
    365
    Posts
    5

    Re: Google Sheets - Help with formular to calculate percentage

    Thanks for the help but unfortunately it keeps me throwing an error:

    Attachment 818009

    Any clue why ? Thanks again. I appreciate it.

  4. #4
    Valued Forum Contributor Haluk's Avatar
    Join Date
    02-14-2019
    Location
    Turkiye
    MS-Off Ver
    2010 - 64 Bit on Windows-11 (22 H2) 64 Bit
    Posts
    1,150

    Re: Google Sheets - Help with formular to calculate percentage

    Maybe because of your regional settigs..... I am not sure.

    Try using semicolon instead of commas, that is;

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-07-2019
    Location
    Turkey-Ankara-Çubuk
    MS-Off Ver
    Office 2010
    Posts
    55

    Re: Google Sheets - Help with formular to calculate percentage

    Your arrayformula works
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    formula for C2 (not arrayformula)
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by veyselemre; 02-16-2023 at 09:57 AM.

+ 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. [SOLVED] Formular to calculate percentage
    By issa.o in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2022, 12:11 PM
  2. Automated percentage calculation on Google Sheets
    By djmedzy in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 09-15-2021, 09:17 AM
  3. [SOLVED] Google Sheets: Calculate Next Expiration/Renewal Dates
    By meanpb in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 08-15-2021, 03:27 PM
  4. Google Sheets: Ignore Errors and Calculate Average
    By Manikandan Arumugam in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 13
    Last Post: 06-07-2020, 12:39 AM
  5. Google sheets: Calculate weight lost
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 12
    Last Post: 08-16-2018, 03:54 AM
  6. Google Sheets: Calculate longest winning streak
    By yonifx in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 17
    Last Post: 12-28-2017, 01:43 PM
  7. Formular to calculate variation percentage
    By cashflaw in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-26-2013, 02:28 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