Thread: help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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