Solved: The Brackets were in the Wrong Place. Problem With If Function

[Certificates!]

I have three individual Ifs, that all work successfully on their own

IF(E3="Better Ball",MAX(N9,Q9,T9,W9))

IF(E3="Three Man Am-Am",SUM(MAX((N9,Q9,T9,W9),{1}))+SUM(MAX((N9,Q9,T9,W9),{2})))

IF(E3="Four Man Am-Am",SUM(MAX((N9,Q9,T9,W9),{1}))+SUM(MAX((N9,Q9,T9,W9),{2})))

If I put them together like this: IF(E3="Better Ball",MAX(N9,Q9,T9,W9),IF(E3="Three Man Am-Am",SUM(MAX((N9,Q9,T9,W9),{1}))+SUM(MAX((N9,Q9,T9,W9),{2}))),IF(E3="Four Man Am-Am",SUM(MAX((N9,Q9,T9,W9),{1})+SUM(MAX((N9,Q9,T9,W9),{2}))))), N9) I get a VALUE error, I have tried this as an array function too.

What I am trying to get is: If E is "Better Ball" the maximumof the four cells, if it either of the others, the highest two values, otherwise just the value from N9

Thanks

 

[vletm]

Certificates!
Your thread's title starts with word Solved.
... that should mean - this thread is ... solved...
But still You're writing What I am trying to get is...
What is Your point?

 

[Certificates!]

I wrote the thread, but subsequently solved the problem. I amened it to solved so pople would look at it and waste their time