Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|