WalkieTalkie
Technical User
I hope this is an easy one for someone to answer - I've searched everywhere and can't find any explanation.
What do {} parentheses mean when they are at the beginning and end of a formula in a cell in an excel worksheet? Here's an example of what I mean:
gives a different result than:
I'd appreciate any help you can give me...
Thanks
Miranda
What do {} parentheses mean when they are at the beginning and end of a formula in a cell in an excel worksheet? Here's an example of what I mean:
Code:
{=SUM(IF($A$2:$A$168="h",IF($C$2:$C$168="",1,0)))}
Code:
=SUM(IF($A$2:$A$168="h",IF($C$2:$C$168="",1,0)))
I'd appreciate any help you can give me...
Thanks
Miranda