# Excel formula help

Hi,
Can any please tell me what '{' , '}' means in excel formula
I am looking at a formula as, {=IF(\$s93= "", "-", MIN(if(KeyABC = \$S93, DealStartDates, "n/a")))}
Now if I click inside the formula and press enter. The '{ }' brackets are not therd and formula ends up as
=IF(\$s93= "", "-", MIN(if(KeyABC = \$S93, DealStartDates, "n/a")))

Which doesnt calculate to what it should.
I am quiet sure its something simple but being not very experienced user I dont understand it.
It would be great if some one could help me out with it.

Thanks
Patrick Matthews

membership
Create an account to see this answer
Signing up is free. No credit card required.

thanks mat. I could sort judge that its an array formula. now I know that you to hit 'Ctrl+Shift+Enter '

It appears to be doing a "MINIF".  No such function exists in Excel of course, so an array formula is needed.

If S93 is blank, then the output is "-".

If not, it is taking the minimum numeric value from DealStartDates where the corresponding cells in KeyABC equal the value in S93.

ok here what I dont understand how to print

Logically I do understand that -> if(KeyABC = \$S93, DealStartDates, "n/a") - would  return an array
out of which Min(if(KeyABC = \$S93, DealStartDates, "n/a")) - picks the minimum value

But how can you print the whole array?
SameerMirza,

I'm confused.  What are you trying to do?

Patrick