| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell recognition
What type of formula do you need to use so that it doesnt come into effect
until a given cell has a wriiten value in it? ie, for numbers you could do" if A10 then ....... i need something that'll define text, "If A1= "Text", then .... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell recognition
Try
=If(A1<"", ... Regards, Stefi €˛Euan Ritchie€¯ ezt Ć*rta: What type of formula do you need to use so that it doesnt come into effect until a given cell has a wriiten value in it? ie, for numbers you could do" if A10 then ....... i need something that'll define text, "If A1= "Text", then .... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell recognition
Maybe
=IF(A1="MyText",execute my formula,do nothing) Mike "Euan Ritchie" wrote: What type of formula do you need to use so that it doesnt come into effect until a given cell has a wriiten value in it? ie, for numbers you could do" if A10 then ....... i need something that'll define text, "If A1= "Text", then .... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell recognition
Maybe you meant: =IF(ISTEXT(A1), ...
although your post sounds like: =if(A1="Text", ... -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Euan Ritchie" wrote: What type of formula do you need to use so that it doesnt come into effect until a given cell has a wriiten value in it? ie, for numbers you could do" if A10 then ....... i need something that'll define text, "If A1= "Text", then .... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for recognition | Excel Discussion (Misc queries) | |||
| speech recognition | Excel Discussion (Misc queries) | |||
| cell color recognition | Excel Discussion (Misc queries) | |||
| Word recognition | Excel Discussion (Misc queries) | |||
| Speech recognition | Excel Discussion (Misc queries) | |||
Linear Mode
