View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Cell result dependant on a word

On Tue, 4 Aug 2009 02:58:01 -0700, Scoober
wrote:

Altough this completes the formula correctly it doesn't calculate a 0 when
Bare Land is written in f19?


Most likely, F19 does not really contain "Bare Land". There may be extraneous
non-printing characters. Or the space between the two words may not be ASCII
code 32.

--ron