View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mikeice[_32_] Mikeice[_32_] is offline
external usenet poster
 
Posts: 1
Default Help with Count Function


I currently have a cell with formula
=IF(E10="","","Characters")

So it returns the number of characters input in cell -

=IF(B11="","",IF(B11255,"PLEASE GO BACK TO E10 and
PUT IN AN ALT ENTER",""))

What I want is either the amount of characters between the Alt Enters
or if the alt enters are inserted and the text is less than 255 between
those returns that the message doesn't appear.

is that possibel?




--
Mikeice
------------------------------------------------------------------------
Mikeice's Profile: http://www.excelforum.com/member.php...o&userid=22467
View this thread: http://www.excelforum.com/showthread...hreadid=393533