Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=AND($B$12<"",$B$12<TODAY()+60) What does the < mean in this?
Formula above has < and then the double quotes. In the context of the cell
B12, what does the < mean and does the Double Quotes mean, the current cell of B13 will be "nothing" in the cell? Just a little confused, haven't run across this formula, yet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=AND($B$12<"",$B$12<TODAY()+60) What does the < mean in this?
< means not equal to
"" means blank (or empty) B12<"" means B12 is not equal to blank (or empty) -- Biff Microsoft Excel MVP "Cbeckwith" wrote in message ... Formula above has < and then the double quotes. In the context of the cell B12, what does the < mean and does the Double Quotes mean, the current cell of B13 will be "nothing" in the cell? Just a little confused, haven't run across this formula, yet. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=AND($B$12<"",$B$12<TODAY()+60) What does the < mean in this?
< means not equal to and "" means blank So if B12 is not blank...
"Cbeckwith" wrote: Formula above has < and then the double quotes. In the context of the cell B12, what does the < mean and does the Double Quotes mean, the current cell of B13 will be "nothing" in the cell? Just a little confused, haven't run across this formula, yet. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=AND($B$12<"",$B$12<TODAY()+60) What does the < mean in this?
< means not equal
"" is an string with no text That formula is checking for a cell being less than 60 days ago, but it doesn't want to include a cell where there is no date. -- HTH Bob "Cbeckwith" wrote in message ... Formula above has < and then the double quotes. In the context of the cell B12, what does the < mean and does the Double Quotes mean, the current cell of B13 will be "nothing" in the cell? Just a little confused, haven't run across this formula, yet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"NOW" or "TODAY" date function | Excel Worksheet Functions | |||
How can I use the "TODAY ()" Function in an "IF/THEN" calculation | Excel Worksheet Functions | |||
IF(D2="Paid","",IF(C2="","",IF(TODAY()<C2,"",IF(TODAY()-C214,"Ove | Excel Discussion (Misc queries) | |||
=IF((TODAY()-B8)30, "Overdue", "Current"), | Excel Discussion (Misc queries) |