Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with nested IF_OR statement
I am using a nested IF_OR statement to evaluate a list of values to see if
any of them are 100, and to return YES if they are, and NO if they are not. When I enter the formula using the formula palette, the value shown in the palette is NO which is correct, however #VALUE! is displayed in the cell. I have checked and the formula is entered correctly. I am completely perplexed. Any help would be appreciated. |
#2
|
|||
|
|||
Post your formula.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... I am using a nested IF_OR statement to evaluate a list of values to see if any of them are 100, and to return YES if they are, and NO if they are not. When I enter the formula using the formula palette, the value shown in the palette is NO which is correct, however #VALUE! is displayed in the cell. I have checked and the formula is entered correctly. I am completely perplexed. Any help would be appreciated. |
#3
|
|||
|
|||
=IF(OR(B55:B175100),"YES","NO")
"RagDyeR" wrote: Post your formula. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... I am using a nested IF_OR statement to evaluate a list of values to see if any of them are 100, and to return YES if they are, and NO if they are not. When I enter the formula using the formula palette, the value shown in the palette is NO which is correct, however #VALUE! is displayed in the cell. I have checked and the formula is entered correctly. I am completely perplexed. Any help would be appreciated. |
#4
|
|||
|
|||
Do you realize that your formula is an *array* formula?
-- Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of the regular <Enter, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DOOGIE" wrote in message ... =IF(OR(B55:B175100),"YES","NO") "RagDyeR" wrote: Post your formula. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... I am using a nested IF_OR statement to evaluate a list of values to see if any of them are 100, and to return YES if they are, and NO if they are not. When I enter the formula using the formula palette, the value shown in the palette is NO which is correct, however #VALUE! is displayed in the cell. I have checked and the formula is entered correctly. I am completely perplexed. Any help would be appreciated. |
#5
|
|||
|
|||
No, I did not realize that. I tried it and it works! Excel has a lot of odd
quirks. Thank you very much! "Ragdyer" wrote: Do you realize that your formula is an *array* formula? -- Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of the regular <Enter, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "DOOGIE" wrote in message ... =IF(OR(B55:B175100),"YES","NO") "RagDyeR" wrote: Post your formula. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... I am using a nested IF_OR statement to evaluate a list of values to see if any of them are 100, and to return YES if they are, and NO if they are not. When I enter the formula using the formula palette, the value shown in the palette is NO which is correct, however #VALUE! is displayed in the cell. I have checked and the formula is entered correctly. I am completely perplexed. Any help would be appreciated. |
#6
|
|||
|
|||
There's really nothing odd about array formulas.
They have their place, where there might not be any other way to accomplish a calculation. In your case however, you could use a non-array formula to do the same job: =IF(COUNTIF(B55:B175,"100")0,"YES","NO") -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... No, I did not realize that. I tried it and it works! Excel has a lot of odd quirks. Thank you very much! "Ragdyer" wrote: Do you realize that your formula is an *array* formula? -- Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of the regular <Enter, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "DOOGIE" wrote in message ... =IF(OR(B55:B175100),"YES","NO") "RagDyeR" wrote: Post your formula. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... I am using a nested IF_OR statement to evaluate a list of values to see if any of them are 100, and to return YES if they are, and NO if they are not. When I enter the formula using the formula palette, the value shown in the palette is NO which is correct, however #VALUE! is displayed in the cell. I have checked and the formula is entered correctly. I am completely perplexed. Any help would be appreciated. |
#7
|
|||
|
|||
Thanks again!
"RagDyeR" wrote: There's really nothing odd about array formulas. They have their place, where there might not be any other way to accomplish a calculation. In your case however, you could use a non-array formula to do the same job: =IF(COUNTIF(B55:B175,"100")0,"YES","NO") -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... No, I did not realize that. I tried it and it works! Excel has a lot of odd quirks. Thank you very much! "Ragdyer" wrote: Do you realize that your formula is an *array* formula? -- Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of the regular <Enter, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "DOOGIE" wrote in message ... =IF(OR(B55:B175100),"YES","NO") "RagDyeR" wrote: Post your formula. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... I am using a nested IF_OR statement to evaluate a list of values to see if any of them are 100, and to return YES if they are, and NO if they are not. When I enter the formula using the formula palette, the value shown in the palette is NO which is correct, however #VALUE! is displayed in the cell. I have checked and the formula is entered correctly. I am completely perplexed. Any help would be appreciated. |
#8
|
|||
|
|||
And thank you for the feed-back.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "DOOGIE" wrote in message ... Thanks again! "RagDyeR" wrote: There's really nothing odd about array formulas. They have their place, where there might not be any other way to accomplish a calculation. In your case however, you could use a non-array formula to do the same job: =IF(COUNTIF(B55:B175,"100")0,"YES","NO") -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... No, I did not realize that. I tried it and it works! Excel has a lot of odd quirks. Thank you very much! "Ragdyer" wrote: Do you realize that your formula is an *array* formula? -- Array formulas must be entered with CSE, <Ctrl <Shift <Enter, instead of the regular <Enter, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. -- HTH, RD -------------------------------------------------------------------------- - Please keep all correspondence within the NewsGroup, so all may benefit ! -------------------------------------------------------------------------- - "DOOGIE" wrote in message ... =IF(OR(B55:B175100),"YES","NO") "RagDyeR" wrote: Post your formula. -- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit ! -------------------------------------------------------------------- "DOOGIE" wrote in message ... I am using a nested IF_OR statement to evaluate a list of values to see if any of them are 100, and to return YES if they are, and NO if they are not. When I enter the formula using the formula palette, the value shown in the palette is NO which is correct, however #VALUE! is displayed in the cell. I have checked and the formula is entered correctly. I am completely perplexed. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Problem with data using IF and Nested IF statements possibly??? | Excel Discussion (Misc queries) |