Logical function

[bchgnn]

Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I'm trying to do a logical function and I can't figure out where to put what....I want to say if the word "fabric" appears in column a, then column b should be 100% or if accessories appears in column a then column be should be 30%....and so on. I have looked at the IF/Then/Value Help and I can't figure out what to do since I'm using text instead of values. Please help! Mary

 

[Carl Witthoft]

Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I'm trying to do a logical function and I can't figure out where to put
what....I want to say if the word "fabric" appears in column a,
then column b should be 100% or if accessories appears in column a then
column be should be 30%....and so on. I have looked at the IF/Then/Value
Help and I can't figure out what to do since I'm using text instead of
values. Please help! Mary

see FIND()

then something like IF(iSNUMBER(FIND(A1,"fabric")), 100%, [something
else])

where you can stick a similar IF(())) in for the [something else] part.

 

[bchgnn]

> (e-mail address removed) wrote:
>

> > Operating System: Mac OS X 10.5 (Leopard)
> > Processor: Intel
> >
> > I'm trying to do a logical function and I can't figure out where to put
> > what....I want to say if the word "fabric" appears in column a,
> > then column b should be 100% or if accessories appears in column a then
> > column be should be 30%....and so on. I have looked at the IF/Then/Value
> > Help and I can't figure out what to do since I'm using text instead of
> > values. Please help! Mary

>
> see FIND()
>
> then something like IF(iSNUMBER(FIND(A1,"fabric&quot), 100%, [something
> else])
>
> where you can stick a similar IF(())) in for the [something else] part.
>
> --
> Team EM to the rescue! http://www.team-em.com
> Thanks so much. I will try it and let you know how it goes. [/QUOTE]

 

[Carl Witthoft]

Once you have entered the formula for row 1, simply drag it down for
as far as you want, and the roe numbers will automatically update.

^^^

Dunno... sounds fishy to me.
~_*

 

[bchgnn]

Thanks all. Didn't get back to this project today, but I will in the morning. Appreciate the help!