Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
fx="<="&B3 ??
Do you know what this mean?
I look at a worksheet and found this but not understand what is it? Thanks Daniel |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |