Hello Richard,

I have been studying your Excel Expert series daily. I use Excel (as many analysts do) on a daily basis. There is one aspect though that I stumble on and that is understanding the context of closing parantheses (particularly how many parantheses go at the end of an equation and where to place them inside of the equation) while nesting functions. For some reason it throws me.
I know you are busy producing materiel, but if you have a spare moment, would you be so kind and tell me which area of your series discusses this and, if none does, could you share some insight on thi matter.
I would really appreciate it.
Thank you.

Reagrds

---

RR:
You should have the same number of closing parentheses as you do opening parentheses. Each function should stand alone. So if you have:

IF(x,y,z)

And you want to nest another IF statement in there, you would have:

IF(x,y,IF(a,b,c))

Now if you pulled it apart, each IF function would stand by itself. 2 open parens, 2 closing parens. Later versions of Excel make this even more apparent by color-coding the parens for you.