problem: "You entered too many arguments for this function"
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!
|