"dated if" statement

IF(AND(DATEDIF(Q14,V$7,"Y")-2,$C14=$C$1),($AA$2*8/24)*
($E14/40)

Hi, I am working on a set of dated if statement that I
have copied from an old worksheet. This piece of it isn't
working. Its the -2 that is the problem and I can't find
anything in help to tell me why its a negative number or
what it means so I can adapt it. Can anyone tell me what
the "-" is for?

Thanks,


Todd

For help on datedif, checkout

http://cpearson.com/excel/datedif.htm

In article ,
"todd" wrote:

IF(AND(DATEDIF(Q14,V$7,"Y")-2,$C14=$C$1),($AA$2*8/24)*
($E14/40)

Hi, I am working on a set of dated if statement that I
have copied from an old worksheet. This piece of it isn't
working. Its the -2 that is the problem and I can't find
anything in help to tell me why its a negative number or
what it means so I can adapt it. Can anyone tell me what
the "-" is for?

Thanks,


Todd

Todd,

You can look for help on datedif at Chip Pearson's site:
http://www.cpearson.com/excel/datedif.htm

Regards,
Felipe
-----Original Message-----
IF(AND(DATEDIF(Q14,V$7,"Y")-2,$C14=$C$1),($AA$2*8/24)*
($E14/40)

Hi, I am working on a set of dated if statement that I
have copied from an old worksheet. This piece of it
isn't
working. Its the -2 that is the problem and I can't find
anything in help to tell me why its a negative number or
what it means so I can adapt it. Can anyone tell me what
the "-" is for?

Thanks,


Todd
.

Todd,

The minus symbol in your formula is the negative symbol indicating the 2 is
a negative number.

The datedif formula says:

If the number of years (years is represented by the "Y" in your formula)
between cell Q14 and V$7 is greater than negative 2

AND

the value of $C14 equals the value of $C$1 then multiply $AA$2*8/24 then
multiply this by $E14 divided by 40

When you add the $ dollar sign beside a cell reference it anchors the cell
pointer.
As an example:
When $A$1 is in a formula, no matter where you copy the formula it will
always reference the same column and the same row (A1).

When $A1 is in a formula, no matter where you copy the formula it will
always reference the same COLUMN but NOT the same ROW. The row number will
adjust according to where you copy the formula.

When A$1 is in a formula, no matter where you copy the formula it will
always reference the same ROW but NOT the same COLUMN. The column letter
will adjust according to where you copy the formula.

Regards,

WShelton
"todd" wrote in message
...
IF(AND(DATEDIF(Q14,V$7,"Y")-2,$C14=$C$1),($AA$2*8/24)*
($E14/40)

Hi, I am working on a set of dated if statement that I
have copied from an old worksheet. This piece of it isn't
working. Its the -2 that is the problem and I can't find
anything in help to tell me why its a negative number or
what it means so I can adapt it. Can anyone tell me what
the "-" is for?

Thanks,


Todd