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