{} Brackets

[Directlinq]

Can Someone please help me
I have a formula

{=IF(OR(D9=M4:S99),"m")}

For instance

This formula works
But when i click in the cell to edit the formula the {} (at the beginning and end) disapear and the formula no longer works.
If i add them back manually the formula still does not work.

How can i edit these formulas without stopping them working.

Many Thanks

Sorry if this is a noob question

[dominicb]

Good morning Directling

But when i click in the cell to edit the formula the {} (at the beginning and end) disapear and the formula no longer works.
If i add them back manually the formula still does not work.

This is an array formula. To commit the formula use Ctrl + Shift + Enter. Not just Enter.

For more on array formulae, and what they're all about, look here.

HTH

DominicB

[DonkeyOte]

On an aside the function in question:

{=IF(OR(D9=M4:S99),"m")}

c(sh)ould be replaced with a non-array formula

=IF(COUNTIF(M4:S99,D9),"m")

[Directlinq]

Thank you so much
Worked a treat