Then B2 is not a real empty cell

As you can see, the first test is to check if B2="" and if so return "", then do nothing else
Perhaps it is not empty but blank ( check with the ISBLANK formula) or contains a hidden value

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post