You must see Null there..You can Edit it to Independent
IF TRIM([Hotel Chain]) = '' THEN 'Independent' ELSE [Brand] END
after TRIM([Hotel Chain]) =, that is two single-quote marks - not one double-quote mark. The idea is to check for an empty string. the TRIM function is used to avoid issues when that field is populated with one or more spaces.