I have input the following formula: =IF(Q4:U4="","ZZ",A4)

When I go to the Function Arguments dialog box, it shows the formula result
as the correct result. But in the spreadsheet it shows #VALUE!

Why isn't it showing this in the spreadsheet? Thank you for your assistance.