Custom Column String comparison not working

[SamWhite]

I have excel file which has a column called Result, it has either values of "Approved" or null. I am writing a if function in custom column which is checking few conditions like:

if [Required]=true then "Yes"

else if [Result]="Approved" then "Completed"

else "Not Completed"

However in the Result whereever Result is Approved, it Error in the new custom column. Other If results are fine.

Results is Text coulmn. Please suggest how to make this  if statement work  else if [Result]="Approved"  then "Completed"

[SamWhite]

Expression.Error: We cannot convert the value null to type Logical.

Details:

Value=

Type=[Type]

This is the error.

[mahenkj2]

As error suggests, your that column is having nulls, and we may be testing it for some value.

Compare with my sample data, check, else share a sample data pls.

[mahenkj2]

Hi @SamWhite ,

the shared formulae just works well for the condition you state:

Hope it helps.

[dufoq3]

Hi, are you sure that you have boolean values true or false in [Required] column? In my opition you have text values "true" or "false" there. If I'm correct, this should help you:

if [Required]="true" then "Yes"
else if [Result]="Approved" then "Completed"
else "Not Completed"

[SamWhite]

The error is not on the boolean value. The error is for the below line:

else if [Result]="Approved" then "Completed"

 Where-ever Result is equal to Approved is not resulting in Completed. It gives ERROR is the custom coulmn. 

[dufoq3]

Provide at least screenshot od your data - mentioned columns and screenshot of error please.