"dated if" statement

  • Thread starter Thread starter todd
  • Start date Start date
T

todd

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
 
Back
Top