Yes, the AND() Function can take up to 30 different conditions (if I
remember correctly), It will return TRUE only if all of the conditions
evaluate to TRUE, otherwise it returns FALSE.

Max_power wrote:
I apologise for being a bit of a nuisance but is it possible to have
multiple conditions in the criteria ie

=IF(AND(A1<\"TOM\",A1<0,A0),1,0)

So I'm trying to say that if cell a1 is not equal to Tom,0 and is
greater than 0 then 1 applies otherwise 0

Many thanks once again

Max


--
Max_power
------------------------------------------------------------------------
Max_power's Profile: http://www.excelforum.com/member.php...o&userid=32255
View this thread: http://www.excelforum.com/showthread...hreadid=558834