fx="<="&B3 ??

[Guest]

Do you know what this mean?

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

Thanks
Daniel

 

[Peo Sjoblom]

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


--


Regards,


Peo Sjoblom

 

[Guest]

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]

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