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
|