problem: "You entered too many arguments for this function"

Here's what excel is allowing me to use right now:
=IF((COUNTBLANK(G6:G12))>0,IF(T12>40,IF(T11>40,0,(40-T11)-H12),U12-H12),0)

I need to have another conditional in there to complete the equation, but
excell wont let me, it just says this: "You entered too many arguments for
this function"

I've created equations containing 6 conditionals all wrapped within, on the
same chart that this one is on. Why is it telling me this when I'm only
trying to do 4 now? here's what I need to add

=IF((COUNTBLANK(G6:G12))>0,IF(T12>40,IF(T11>40,0,

IF(((40-T11)-H12)>0,

(40-T11)-H12),

0)

,U12-H12),0)


Please help!

I think it should be something like this:

=IF(COUNTBLANK(G6:G12)>0,IF(T12>40,IF(T11>40,0,IF(40-T11-H12>0,40-T11-
H12,0)),U12-H12),0)

I've got rid of some brackets which are not needed and moved a closed
bracket after the second H12 term.

Hope this helps.

Pete

On Aug 6, 11:49 pm, Sam Giddy <Sam Gi....DeleteThis@discussions.microsoft.com>
wrote:
> Here's what excel is allowing me to use right now:
> =IF((COUNTBLANK(G6:G12))>0,IF(T12>40,IF(T11>40,0,(40-T11)-H12),U12-H12),0)
>
> I need to have another conditional in there to complete the equation, but
> excell wont let me, it just says this:  "You entered too many arguments for
> this function"
>
> I've created equations containing 6 conditionals all wrapped within, on the
> same chart that this one is on.  Why is it telling me this when I'm only
> trying to do 4 now?  here's what I need to add
>
> =IF((COUNTBLANK(G6:G12))>0,IF(T12>40,IF(T11>40,0,
>
> IF(((40-T11)-H12)>0,
>
> (40-T11)-H12),
>
> 0)
>
> ,U12-H12),0)
>
> Please help!