RE: Testing a cell value

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

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


"Trevor Williams" wrote:

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.

"Finance Guru" wrote:

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.
.

Relevant Pages

  • Re: how to return the col & row of result cell
    ... But still the INDEX function is not required. ... Trevor Shuttleworth wrote: ... > "Frank Kabel" wrote in message ... what if I want to know what cell has minimum value? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Clear formulae
    ... "Trevor Shuttleworth" wrote in message ... > Sub FormulaeToValues3() ... > Dim cell As Range ... > "Paul B" wrote in message ...
    (microsoft.public.excel.programming)
  • Re: Clear formulae
    ... Trevor, "The alternative approach of copy / paste special values would also ... Paul B ... > Sub FormulaeToValues3() ... > Dim cell As Range ...
    (microsoft.public.excel.programming)
  • Re: Formula
    ... Vaya con Dios, ... "Trevor" wrote: ... >> If you want a cell to always show the same as another, ... >> Andy. ...
    (microsoft.public.excel.newusers)
  • Re: How can I prevent cells from being changed by users
    ... Trevor, not exactly what you asked for but this might help, once the data ... Set MyRange = Intersect, Target) ... > alterations after todays date - in other words - protect past entries ... > i know i can locked cells so that when a sheet is protected - the cell ...
    (microsoft.public.excel)