Formula not working in Google Sheets

**henrysauvage** · 01-17-2023, 12:08 PM

Hello,

I am having trouble getting a formula to work in Google Sheets. The formula I am using is:

=IF(NOT(ISBLANK(Kalender!L28)), Kalender!$L$1&" "&Kalender!L28 , "")

The formula is supposed to check if the cell L28 on the sheet "Kalender" is empty and if it's not, it should concatenate the content of cell L1 on the sheet "Kalender" with a space and the content of cell L28 on the sheet "Kalender", and if the cell L28 is empty, it should not insert any content. However, when I enter this formula in a cell, it gives me an error message "Error parsing formula".

I have checked that the sheet name "Kalender" and cell addresses L1 and L28 are spelled correctly and that they exist in my spreadsheet. I also have the necessary permissions to access these cells. I also tried an alternative formula:

=IF(LEN(Kalender!L28)>0, Kalender!$L$1&" "&Kalender!L28, "")

But it also gave me the same error.
I've noticed that the formula =Kalender!$L$1&" "&Kalender!L28 does work, but I need to check if the cell L28 is not empty before concatenating.

I am not sure what the problem is and would appreciate any help or suggestions.

Thank you.

**MrShorty** · 01-17-2023, 12:38 PM

I don't replicate the error. When I set up a new sheet and copy those formulas in, I get no error, and I get the expected result.

One somewhat common "error" (related to locale settings) is using commas to separate the function arguments. Is it possible that your locale settings are requiring semi-colons or some other character as the argument separator? =IF(NOT(ISBLANK(Kalender!L28)); Kalender!$L$1&" "&Kalender!L28 ; "")

**henrysauvage** · 01-17-2023, 12:52 PM

Thank you so much for your help, the formula you provided: =IF(NOT(ISBLANK(Kalender!L28)); Kalender!$L$1&" "&Kalender!L28 ; "") worked perfectly and solved the problem.

I apologize for not mentioning the possibility of the separator character being the issue earlier. Your suggestion to change the separator character to a semicolon was the key to solving the problem.

Thank you again for your help and for taking the time to assist me.