Here's what excel is allowing me to use right now:
=IF((COUNTBLANK(G6:G12))0,IF(T1240,IF(T1140,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(T1240,IF(T1140,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(T1240,IF(T1140,0,IF( 40-T11-H120,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
wrote:
Here's what excel is allowing me to use right now:
=IF((COUNTBLANK(G6:G12))0,IF(T1240,IF(T1140,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(T1240,IF(T1140,0,

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

(40-T11)-H12),

0)

,U12-H12),0)

Please help!