Hi All,

I am using Excel 2007.

My problem is this. I have a list box ( B1 ) from which the following
options can be selected ie. Open , Pending, Closed. At the moment I have the
following function in A1 =IF(B1="Closed",FINAL VERSION","DRAFT")

What I really want to do is in A1 is test B1 for the "Open" or "Pending"
which if either are selected then "DRAFT VERSION" will apear in A1 and if
"Closed" is selected then "FINAL VERSION" will be displayed in A1

I believe this can be done IF AND OR combined but it is beyond me.

Thank you in advance

Regards
FinanceGuru
--------------
Wales - the land of fire breathing dragons and rugby pllaying wizards.