Testing a cell value
 

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.

Testing a cell value
 

Hi Finance Guru -- try this:

=IF(OR(B1="Open",B1="Pending"),"DRAFT VERSION",IF(B1="Closed","FINAL
VERSION",""))

HTH
Trevor Williams

"Finance Guru" wrote:


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.

Testing a cell value
 

Hi Trevor,

If "open" is selected from the list box the other cell displays FALSE. If
any other criteria is selected the it displays the correct result ie. Pending
= Draft,Closed = Final"



Wales - the land of fire breathing dragons and rugby playing wizards.


"Trevor Williams" wrote:

Hi Finance Guru -- try this:

=IF(OR(B1="Open",B1="Pending"),"DRAFT VERSION",IF(B1="Closed","FINAL
VERSION",""))

HTH
Trevor Williams

"Finance Guru" wrote:


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.