fx="<="&B3 ??
 

Do you know what this mean?

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

Thanks
Daniel

fx="<="&B3 ??
 

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

fx="<="&B3 ??
 

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

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