Nested functions HELP!

[Guest]

=IF((C6>0)*AND(S24=50,60),M6/5,M6/6)...This function works as I desire,
however I want to add a third option where S24 would =70 and M6/7. An error
occurs stating too many arguments enterd. Can some help me??

 

[Biff]

Hi Sandy!

If it saves key strokes, it's better! <g>

Nice one! I didn't even "see" that!

Biff

 

[Guest]

=IF((C6>0)*AND(S24=50,60),M6/5,M6/6)...

In the above statement, C6 refers to a cell that if anything is there it
will Reference S24 which will be placed there by another sheet, depending on
if 50 hours, 60 hours or 70 hours are scheduled. At that point M6 which is a
$ amount is then divided by 5 or 6 or 7. Depending on S24 being 50 or 60 or
70. The above formula works well for the first 2 but once a third is added it
no longer works.

 

[Harlan Grove]

Sandy Mann wrote...

Can be shortened, (but is not necessarily faster or better):


=IF(AND(C6>0,OR(S24={50,60,70})),M6/(S24/10),"Not defined")

....

Could be shortened a bit further.

=IF((C6>0)*OR(S24={50;60;70}),M6*10/S24,"Not defined")

 

[Guest]

=IF((C6>0)*AND(S24=50,60),M6/5,M6/6)...
This is how the formula should read, but let me explain what is happening.

1)On a seperate worksheet it is determined that either 50, 60, or 70 hours
will be scheduled for a particular agent for a given week.

2)On 2nd worksheet C6 will be the amount of hrs that agent worked for that
day. It really does not matter if it is 1 hr or more since the individual is
a salary employee. Thus the need to determine how much each day's cost is for
the individual, given that if he works 5 days that week (50) or 6 days(60) or
7 days(70).

=IF((C6>0)*AND(S24=50,60),M6/5,M6/6)...
C6>0 indicates the individual actually worked as scheduled.
S24=50,60 where S24 is the hrs scheduled for the individual.
M6/5 and M6/6 and M6/7 is salary divided by days scheduled thus getting a
dollar value for each day that is worked, and then reported .

Hope this is now clearer than mud.
The Chief

 

[Biff]

See the replies by Sandy or Harlan.

Biff

=IF((C6>0)*AND(S24=50,60),M6/5,M6/6)...
This is how the formula should read, but let me explain what is happening.

1)On a seperate worksheet it is determined that either 50, 60, or 70 hours
will be scheduled for a particular agent for a given week.

2)On 2nd worksheet C6 will be the amount of hrs that agent worked for that
day. It really does not matter if it is 1 hr or more since the individual
is
a salary employee. Thus the need to determine how much each day's cost is
for
the individual, given that if he works 5 days that week (50) or 6 days(60)
or
7 days(70).

=IF((C6>0)*AND(S24=50,60),M6/5,M6/6)...
C6>0 indicates the individual actually worked as scheduled.
S24=50,60 where S24 is the hrs scheduled for the individual.
M6/5 and M6/6 and M6/7 is salary divided by days scheduled thus getting a
dollar value for each day that is worked, and then reported .

Hope this is now clearer than mud.
The Chief