Thread: fx="<="&B3 ??
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default fx="<="&B3 ??

It's typical when you want to use advanced filter or any of the D functions
where you normally use a header and this one looks to see if the date is in
past send or equal to the date in B3, so if for instance you have a list and
you want to sum all entries in one column where another columns with dates
and only sum those rows that have a date that is less than or equal to a
certain date like yesterday or today if the date in B3 is today but if the
date are tomorrow it won't be included


--

Regards,

Peo Sjoblom
"Daniel" wrote in message
...
Found this in formula entry box of cell B4

="<="&B3

B3 is date fomat

the cell B4 appears to be number

Looks like it change the B4 to be number format and equal or less than B3.

Why use the &?
Why use the "=<" ?

daniel

"Peo Sjoblom" wrote:

Looks like a criteria used for either countif, sumif, the D functions or
the
advanced filter


--


Regards,


Peo Sjoblom



"Daniel" wrote in message
...
Do you know what this mean?

I look at a worksheet and found this but not understand what is it?

Thanks
Daniel