Thread: fx="<="&B3 ??
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default 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