You would then use the "AND" or the "OR" functions.
What do you want to show if there are more than one?

An example of the "AND" function


=IF(AND(A4<0,B40),"yes","no")


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=481998