Find Out:What does this formula mean?

Hi

This looks at the difference in months between K4 and 31st December 04 and
if it is more than or equal to 20, or less than 8 it will put a zero in the
cell. If it is neither of these (ie between 9 and 19) if will put in Q4/12
(ie the figure in cell Q4 divided by 12)

Andy.

"Bucksnut" <[email protected]> wrote in message
news:[email protected]...
> What does this formula mean?
>
> =IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q4/12))

and it can be simplified to

=IF(AND(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
4/12))


--

HTH

RP
(remove nothere from the email address if mailing direct)


<Andy> wrote in message news:[email protected]...
> Hi
>
> This looks at the difference in months between K4 and 31st December 04 and
> if it is more than or equal to 20, or less than 8 it will put a zero in
the
> cell. If it is neither of these (ie between 9 and 19) if will put in Q4/12
> (ie the figure in cell Q4 divided by 12)
>
> Andy.
>
> "Bucksnut" <[email protected]> wrote in message
> news:[email protected]...
> > What does this formula mean?
> >
> >
=IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
4/12))
>
>

Bob

I think you mean:
=IF(OR(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q4/12))

Andy.


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> and it can be simplified to
>
> =IF(AND(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
> 4/12))
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> <Andy> wrote in message news:[email protected]...
>> Hi
>>
>> This looks at the difference in months between K4 and 31st December 04
>> and
>> if it is more than or equal to 20, or less than 8 it will put a zero in
> the
>> cell. If it is neither of these (ie between 9 and 19) if will put in
>> Q4/12
>> (ie the figure in cell Q4 divided by 12)
>>
>> Andy.
>>
>> "Bucksnut" <[email protected]> wrote in message
>> news:[email protected]...
>> > What does this formula mean?
>> >
>> >
> =IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
> 4/12))
>>
>>
>
>

Indeed I did Andy. Thanks

Bob


<Andy> wrote in message news:[email protected]...
> Bob
>
> I think you mean:
>
=IF(OR(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q4
/12))
>
> Andy.
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > and it can be simplified to
> >
> >
=IF(AND(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
> > 4/12))
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > <Andy> wrote in message news:[email protected]...
> >> Hi
> >>
> >> This looks at the difference in months between K4 and 31st December 04
> >> and
> >> if it is more than or equal to 20, or less than 8 it will put a zero in
> > the
> >> cell. If it is neither of these (ie between 9 and 19) if will put in
> >> Q4/12
> >> (ie the figure in cell Q4 divided by 12)
> >>
> >> Andy.
> >>
> >> "Bucksnut" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > What does this formula mean?
> >> >
> >> >
> >
=IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
> > 4/12))
> >>
> >>
> >
> >
>
>

Hi

This looks at the difference in months between K4 and 31st December 04 and
if it is more than or equal to 20, or less than 8 it will put a zero in the
cell. If it is neither of these (ie between 9 and 19) if will put in Q4/12
(ie the figure in cell Q4 divided by 12)

Andy.

"Bucksnut" <[email protected]> wrote in message
news:[email protected]...
> What does this formula mean?
>
> =IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q4/12))

and it can be simplified to

=IF(AND(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
4/12))


--

HTH

RP
(remove nothere from the email address if mailing direct)


<Andy> wrote in message news:[email protected]...
> Hi
>
> This looks at the difference in months between K4 and 31st December 04 and
> if it is more than or equal to 20, or less than 8 it will put a zero in
the
> cell. If it is neither of these (ie between 9 and 19) if will put in Q4/12
> (ie the figure in cell Q4 divided by 12)
>
> Andy.
>
> "Bucksnut" <[email protected]> wrote in message
> news:[email protected]...
> > What does this formula mean?
> >
> >
=IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
4/12))
>
>

Bob

I think you mean:
=IF(OR(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q4/12))

Andy.


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> and it can be simplified to
>
> =IF(AND(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
> 4/12))
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> <Andy> wrote in message news:[email protected]...
>> Hi
>>
>> This looks at the difference in months between K4 and 31st December 04
>> and
>> if it is more than or equal to 20, or less than 8 it will put a zero in
> the
>> cell. If it is neither of these (ie between 9 and 19) if will put in
>> Q4/12
>> (ie the figure in cell Q4 divided by 12)
>>
>> Andy.
>>
>> "Bucksnut" <[email protected]> wrote in message
>> news:[email protected]...
>> > What does this formula mean?
>> >
>> >
> =IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
> 4/12))
>>
>>
>
>

Indeed I did Andy. Thanks

Bob


<Andy> wrote in message news:[email protected]...
> Bob
>
> I think you mean:
>
=IF(OR(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q4
/12))
>
> Andy.
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > and it can be simplified to
> >
> >
=IF(AND(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
> > 4/12))
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > <Andy> wrote in message news:[email protected]...
> >> Hi
> >>
> >> This looks at the difference in months between K4 and 31st December 04
> >> and
> >> if it is more than or equal to 20, or less than 8 it will put a zero in
> > the
> >> cell. If it is neither of these (ie between 9 and 19) if will put in
> >> Q4/12
> >> (ie the figure in cell Q4 divided by 12)
> >>
> >> Andy.
> >>
> >> "Bucksnut" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > What does this formula mean?
> >> >
> >> >
> >
=IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
> > 4/12))
> >>
> >>
> >
> >
>
>

What does this formula mean?

=IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q4/12))

Hi

This looks at the difference in months between K4 and 31st December 04 and
if it is more than or equal to 20, or less than 8 it will put a zero in the
cell. If it is neither of these (ie between 9 and 19) if will put in Q4/12
(ie the figure in cell Q4 divided by 12)

Andy.

"Bucksnut" <[email protected]> wrote in message
news:[email protected]...
> What does this formula mean?
>
> =IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q4/12))

and it can be simplified to

=IF(AND(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
4/12))


--

HTH

RP
(remove nothere from the email address if mailing direct)


<Andy> wrote in message news:[email protected]...
> Hi
>
> This looks at the difference in months between K4 and 31st December 04 and
> if it is more than or equal to 20, or less than 8 it will put a zero in
the
> cell. If it is neither of these (ie between 9 and 19) if will put in Q4/12
> (ie the figure in cell Q4 divided by 12)
>
> Andy.
>
> "Bucksnut" <[email protected]> wrote in message
> news:[email protected]...
> > What does this formula mean?
> >
> >
=IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
4/12))
>
>

Bob

I think you mean:
=IF(OR(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q4/12))

Andy.


"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> and it can be simplified to
>
> =IF(AND(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
> 4/12))
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> <Andy> wrote in message news:[email protected]...
>> Hi
>>
>> This looks at the difference in months between K4 and 31st December 04
>> and
>> if it is more than or equal to 20, or less than 8 it will put a zero in
> the
>> cell. If it is neither of these (ie between 9 and 19) if will put in
>> Q4/12
>> (ie the figure in cell Q4 divided by 12)
>>
>> Andy.
>>
>> "Bucksnut" <[email protected]> wrote in message
>> news:[email protected]...
>> > What does this formula mean?
>> >
>> >
> =IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
> 4/12))
>>
>>
>
>

Indeed I did Andy. Thanks

Bob


<Andy> wrote in message news:[email protected]...
> Bob
>
> I think you mean:
>
=IF(OR(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q4
/12))
>
> Andy.
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > and it can be simplified to
> >
> >
=IF(AND(DATEDIF(K4,"12/31/2004","m")>=20,DATEDIF(K4,"12/31/2004","m")<8),0,Q
> > 4/12))
> >
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > <Andy> wrote in message news:[email protected]...
> >> Hi
> >>
> >> This looks at the difference in months between K4 and 31st December 04
> >> and
> >> if it is more than or equal to 20, or less than 8 it will put a zero in
> > the
> >> cell. If it is neither of these (ie between 9 and 19) if will put in
> >> Q4/12
> >> (ie the figure in cell Q4 divided by 12)
> >>
> >> Andy.
> >>
> >> "Bucksnut" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > What does this formula mean?
> >> >
> >> >
> >
=IF(DATEDIF(K4,"12/31/2004","m")>=20,0,IF(DATEDIF(K4,"12/31/2004","m")<8,0,Q
> > 4/12))
> >>
> >>
> >
> >
>
>