software

I have input the following formula: =IF(Q4:U4=quot;quot;,quot;ZZquot;,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?

gt;=IF(Q4:U4=quot;quot;,quot;ZZquot;,A4)

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

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

quot;Ikeaglequot; gt; wrote in message
...
gt;I have input the following formula: =IF(Q4:U4=quot;quot;,quot;ZZquot;,A4)
gt;
gt; When I go to the Function Arguments dialog box, it shows the formula
gt; result
gt; as the correct result. But in the spreadsheet it shows #VALUE!
gt;
gt; Why isn't it showing this in the spreadsheet? Thank you for your
gt; assistance.
It's an array formula and needs to be entered with ctrl shift amp; enter
Are you checking if any of the cells in Q4:U are blank and if so return quot;ZZquot;
?
then you can use

=IF(COUNTBLANK(Q4:U4)gt;0,quot;ZZquot;,A4)

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Ikeaglequot; gt; wrote in message
...
gt;I have input the following formula: =IF(Q4:U4=quot;quot;,quot;ZZquot;,A4)
gt;
gt; When I go to the Function Arguments dialog box, it shows the formula
gt; result
gt; as the correct result. But in the spreadsheet it shows #VALUE!
gt;
gt; Why isn't it showing this in the spreadsheet? Thank you for your
gt; assistance.