help
 

Is it possible to extract some text from a cell and if a text is given in
this cell an other call will act

Cells a1, a2, a3, a4, a5, a6 are free format cells for input text as PEF or
PER or AVI or even empty

Cell b1 will be "10Deg cell" but if the cell a1 contains PEF of PER cell b1
must be "15 deg cel" but if AVI cell b1 must be "12 deg cell"

Hope somone can help me

help
 

In B1

=IF(OR(A1="PEF", A1="PER"),"15 deg cel",IF(A1="AVI","12 deg cel","10 deg
cel"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fam Buijs" wrote in message
.nl...
Is it possible to extract some text from a cell and if a text is given in
this cell an other call will act

Cells a1, a2, a3, a4, a5, a6 are free format cells for input text as PEF
or
PER or AVI or even empty

Cell b1 will be "10Deg cell" but if the cell a1 contains PEF of PER cell
b1
must be "15 deg cel" but if AVI cell b1 must be "12 deg cell"

Hope somone can help me

help
 

Does this also work if this PER, AVI is part of a entry?

Stefan

"Bob Phillips" wrote in message
...
In B1

=IF(OR(A1="PEF", A1="PER"),"15 deg cel",IF(A1="AVI","12 deg cel","10 deg
cel"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fam Buijs" wrote in message
.nl...
Is it possible to extract some text from a cell and if a text is given in
this cell an other call will act

Cells a1, a2, a3, a4, a5, a6 are free format cells for input text as PEF
or
PER or AVI or even empty

Cell b1 will be "10Deg cell" but if the cell a1 contains PEF of PER cell
b1
must be "15 deg cel" but if AVI cell b1 must be "12 deg cell"

Hope somone can help me

help
 

Hi Stefan,

No, but this should

=IF(OR(ISNUMBER(FIND("PEF",A1)), ISNUMBER(FIND("PER",A1))),"15 deg
cel",IF(ISNUMBER(FIND("AVI",A1)),"12 deg cel","10 deg cel"))

if you want it case-sensitive, change FIND to SEARCH

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fam Buijs" wrote in message
. nl...
Does this also work if this PER, AVI is part of a entry?

Stefan

"Bob Phillips" wrote in message
...
In B1

=IF(OR(A1="PEF", A1="PER"),"15 deg cel",IF(A1="AVI","12 deg cel","10 deg
cel"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Fam Buijs" wrote in message
.nl...
Is it possible to extract some text from a cell and if a text is given
in
this cell an other call will act

Cells a1, a2, a3, a4, a5, a6 are free format cells for input text as
PEF
or
PER or AVI or even empty

Cell b1 will be "10Deg cell" but if the cell a1 contains PEF of PER
cell
b1
must be "15 deg cel" but if AVI cell b1 must be "12 deg cell"

Hope somone can help me