Evaluate a named range as a single value

Steps to Reproduce

1. load formulaNamedRange.xlsx file
2. check B7

Current Result

#VALUE

Expected Result

it's A

Debug Information

• The named range condition_result, contains a 2 cells reference B2:C2
• Excel can evaluate a named range as a single value
• keikai-376.xlsx is a user case

Workaround

• change B2:C2 to 1 cell, B2