| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula in B1
"Pete_UK" wrote: Sorry, Rik, your post wasn't visible when I responded - I thought you might have called it a day. Pete On Dec 16, 1:01 am, Rik_UK wrote: Sure use the following =IF(ISERROR(MATCH(A1,listedwords,0)),"","f") -- Kind regards Rik "Trainee" wrote: "Rik_UK" wrote: As a blank in a1 or any othoer word than the ones listed have the same result they need not be defined... putting this formula in cell b1 will provide the results requested. =IF(OR(A1="green",A1="blue",A1="plant",A1="street" ),"f","") but if when A1 is blank needs to be considered seperately then use the following =IF(A1="","",IF(OR(A1="green",A1="blue",A1="plant" ,A1="street"),"f","")) -- Kind regards Rik "Trainee" wrote: Could somebody be so kind and provide me with a formula to go in B1 that will change this cell accordinly to A1. If A1= blank, then B1= blank If A1= "green" or "blue" or "plant" or "street" (TEXT),then B1 will show letter "f".(all examples without quotation of course) If A1= any other different word, then B1= blank. Thank you very much. It works good, Thanks Rik Uk. Now can the same formula be use with range of words instead of writing each one each time. This come for another worsheet that has 50 words and I need the "f" in B1 too. The range is called "listedwords" Thanks again.- Hide quoted text - - Show quoted text - . Thank you too Peter Uk, you guys are doing a good job. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
