Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Function syntax to compare cell contents | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |