help

  • Thread starter Thread starter Fam Buijs
  • Start date Start date
F

Fam Buijs

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
 
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)
 
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)
 
Back
Top