Why am i getting #VALUE! in a cell?

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.

Hi!

Have you read the replies to your other thread?

>=IF(Q4:U4="","ZZ",A4)

You're comparing a range of cells, Q4:U4, to a single condition, "".

Slow down and give a thorough detailed explanation of what you're trying to
do. I read your other thread and it is confusing! When others respond and
ask for clarification it helps if you reply with the answers to those
questions. If we don't understand what you're doing how can we be expected
to help?

Biff

"Ikeagle" <Ikeagle@discussions.microsoft.com> wrote in message
news:4FFE3DE0-C72E-45E7-9D09-3AAFED207AF9@microsoft.com...
>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.

It's an array formula and needs to be entered with ctrl + shift & enter
Are you checking if any of the cells in Q4:U are blank and if so return "ZZ"
?
then you can use

=IF(COUNTBLANK(Q4:U4)>0,"ZZ",A4)

--
Regards,

Peo Sjoblom

Portland, Oregon




"Ikeagle" <Ikeagle@discussions.microsoft.com> wrote in message
news:4FFE3DE0-C72E-45E7-9D09-3AAFED207AF9@microsoft.com...
>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.