Thread: =AND($B$12"",$B$12TODAY()+60) What does the mean in this?
View Single Post
  #4  
Old March 18th, 2010, 04:34 PM posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_]
external usenet poster
  
Posts: 489
Default =AND($B$12"",$B$12TODAY()+60) What does the mean in this?
means not equal
"" is an string with no text

That formula is checking for a cell being less than 60 days ago, but it
doesn't want to include a cell where there is no date.

--

HTH

Bob

"Cbeckwith" wrote in message
...
Formula above has and then the double quotes. In the context of the
cell
B12, what does the mean and does the Double Quotes mean, the current
cell
of B13 will be "nothing" in the cell?
Just a little confused, haven't run across this formula, yet.