Hi all

I need help with a basic formula

if cell b10 or then display b1, otherwise display a1. This bit is
easy, but the chanllange comes when some of the cells in b contain the
word "Leave". How do i add the second bit in the formula

thanks for the help

andrew


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=491687