Function question

HZAR

Screenshot 2023-12-05 221737.png

Current formula used:=IF([Name A]@row = [Name B]@row, "NO", IF([Name B]@row <> [Name A]@row, "YES"))

What if I need to included the Name is blank and Column Approval required will be return as No coz currently when i used the formula above it return error since it only compare Name A=Name B it will return as No and NAme A<> Name B it will return Yes

Condition required In column Approval required

Name A=Name B No

Name A<> Name B Yes

Name A is blank No

Paul Newcome

Try this:

=IF(OR([Name A]@row = "", [Name A]@row <> [Name B]@row), "NO", "YES")

HZAR

When I copy and paste the formula in it gave me the error as per screenshot

Paul Newcome

What about the formula I provided?

HZAR

hi Paul

I have copy and paste the formula that yo have provided and it gv me the error as per screenshot. Not too sure why.

IF(OR([Name A]@row = "", [Name A]@row <> [Name B]@row), "NO", "YES")

HZAR

Hi Paul

I have resolve the issue that I have encounter. Thanks for the help :)