If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
=AND($B$12"",$B$12TODAY()+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
|
|||
|
|||
=AND($B$12"",$B$12TODAY()+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
|
|||
|
|||
=AND($B$12"",$B$12TODAY()+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
|
|||
|
|||
=AND($B$12"",$B$12TODAY()+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. |
Thread Tools | |
Display Modes | |
|
|