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

S

Sam Giddy

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!
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function Has Too Many Arguments 4
IF function says too many nested 1
Possibly Too Many Arguments 7
Too few arguments 3
IF Statement Problem 3
Nested If returns error (too many arguments) 9
Too many arguments-VLOOKUP instead? 2
IF function with too many arguments 3

Top