|
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 .... |
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 .... |
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 .... |
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 .... |
| All times are GMT +1. The time now is 08:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com