Error in Excel Formula

Question

I got an error message while trying to create an "IF'' formula in Excel.

The problem is my Excel can't add textual value to the logical test. I tried to resolve this using the Insert Function in Excel.

While I try to create a new IF formula. I got this error message '' There's a problem with this formula''

I Run Microsoft 365 on Windows 11.

I tried to resolve the ''IF'' Formula using the Insert Function. However, the Insert Function in Excel can't fix the textual value. I also reinstall Microsoft on my PC. But the problem is still there.

Answer 1

Thank you very much for your assisting! The Problem Resolved.

Answer 2

Thanks. The double quote " is a single character, not two single quotes ' in a row.

On my (US English) keyboard, " is Shift+' but that may be different on keyboards for other languages; for example on a UK English keyboard it is Shift+2.

The formula should be

=IF(C2="Critical", "***", "*")

Answer 3

1. I use a point as a decimal separator (2.5)
2. I used fixed values with double quotes. e.g. ''Critical''
3. Here you go the formula. =if(C2=''Critical'', ''***'', ''*'')
   https://learn-attachment.microsoft.com/api/attachments/194a3592-676d-4336-9ad0-77d9a6a8ae50?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/194a3592-676d-4336-9ad0-77d9a6a8ae50?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">

Answer 4

1. Which character do you use as decimal separator? Point (2.5) or comma (2,5)?
2. Fixed text values must be enclosed in straight double quotes: "some text".
3. Please post the formula you tried to create.