Testing a cell value

  • Thread starter Thread starter Finance Guru
  • Start date Start date
F

Finance Guru

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
 
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's formula works fine on my Excel 2003

are you sure you the last quote "" in the formula? i.e. before the
rightmost double brakets
 
Hi Finance Guru - check that the word Open in your listbox criteria doesn't
contain any spaces (e.g. at the end of the word) -- I presume your listbox is
created using data validation, not from the forms toolbar.
 
Jarek & Trevor,

Thank you both for getting back to me. I couldn't understand either why the
function didn't work.

I cleared the "Open" cell in data validation and retyped the word again,and
now all appears to be working fine. You learn something new everyday!

My sincere thanks to you both,and in particular Trevor for supplying the
formula.

FinanceGuru
 
Back
Top