E Euan Ritchie Jun 4, 2008 #1 What type of formula do you need to use so that it doesnt come into effect
M Max Jun 4, 2008 #4 Maybe you meant: =IF(ISTEXT(A1), ... although your post sounds like: =if(A1="Text", ... [/QUOTE]