See the replies by Sandy or Harlan.

Biff

"chiefnmd" <chiefnmd@verizon.net> wrote in message
news:1045FEDD-13FB-443F-8B06-488B0E59223A@microsoft.com...
> =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
>
>
> "sirknightly" wrote:
>
>>
>> The Chief,
>>
>> I'm not sure what you're trying to accomplish here, and this may be
>> usage I've never encountered before, but there are some parts of your
>> formula that don't make sense:
>>
>> 1) You're multiplying C60 by a logical statement. In essence, you're
>> taking the value of C60 * either TRUE or FALSE. This is fine in
>> essence, but I don't think it's doing what you intend it to.
>>
>> 2) The second argument in your AND statement ("60") is always TRUE. 60
>> is always 60, so there's no reason to include it in a logical
>> statement.
>>
>> 3) The result of the condition in your IF statement (based on the two
>> above) is that your condition will ALWAYS give you M6/6 unless "50" is
>> entered in S24.
>>
>> 4) Because of 3) above, there is no reason to include C60 in the
>> formula. It serves no purpose.
>>
>> From the looks of your formula, what you want it to do is multiply C60
>> by M6 divided by S24 divided by 10. If this is the case, use this
>> formula:
>>
>> =C60*(M6/(S24/10))
>>
>> Let me know if I've misunderstood your intention.
>>
>> Knightly
>>
>> chiefnmd Wrote:
>> > =IF((C60)*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??
>> > --
>> > The Chief
>>
>>
>> --
>> sirknightly
>>