Normally, you type the formula in, and then press the Enter key to commit
it.

But with an array formula, you type it in, and then commit it by pressing
Ctrl-Shift=Enter (all 3 keys) at the same time.If you have done it
correctly, in the formula bar the formula will look like

{=IF(A1=17,"Yes","No")}

that is with the curly braces around it (but with your formula of course).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"union865kri " wrote in message
...
I did use that formula, but I do not understand what you mean by
(entered using control shift enter.) When I copy that formula into the
spreadsheet, it gives me a #value error. When I changed the cell
references to the cells I actually am using in my real spreadsheet, it
gives me this error. And when I press the control, shift and enter key,
nothing happens. I am not a novice using Excel, but I am a novice
understanding an array, and an array formula. Can you be more specific
with your instructions??? If not, I do appreciate what you did tell me.
And thank you Frank from Germany.


---
Message posted from http://www.ExcelForum.com/