Skip to main content
5 events
when toggle format what by license comment
Mar 27, 2021 at 20:08 comment added Erik Tyler You're welcome. Glad it was an easy fix. If you would, please take a moment to mark the answer as "Best Answer." This helps other contributors know at a glance which issues are fully resolved; and it helps future site visitors like yourself quickly find the solutions that might best match their needs. Thanks.
Mar 27, 2021 at 16:51 comment added HASE It worked by changing the commas with semicolon. Tank you Erik for your great help
Mar 27, 2021 at 15:36 comment added Erik Tyler You may be in a locale that uses semicolons where we use commas in the United States. Try changing every comma (4) in the formula to a semicolon and see if that works. If not, please share a link to a sample spreadsheet, being sure to set the link's Share permission (when you create the link) to "Anyone with the link..." and "Editor."
Mar 27, 2021 at 10:59 comment added HASE Thanks for the answer, but the formula doesn't work. it says #ERROR
Mar 26, 2021 at 20:00 history answered Erik Tyler CC BY-SA 4.0