=IF((C60)*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.
--
The Chief
"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
|