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.

Why am i getting #VALUE! in a cell?
 

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" wrote in message
...
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.

Why am i getting #VALUE! in a cell?
 

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" wrote in message
...
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.