You need to include a second S24= preceding the 60 like so:
=IF((C6>0)*AND(S24=50,S24=60),M6/5,M6/6)
--
Regards,
db
"chiefnmd" wrote:
> =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??
> --
> The Chief
Bookmarks