View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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!