ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   What does this formula mean? (https://www.excelbanter.com/excel-worksheet-functions/33364-what-does-formula-mean.html)

Bucksnut

What does this formula mean?
 
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" wrote in message
...
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))




Bob Phillips

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 ...
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" wrote in message
...
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" wrote in message
...
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 ...
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" wrote in message
...
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 Phillips

Indeed I did Andy. Thanks

Bob


<Andy wrote in message ...
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" wrote in message
...
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 ...
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" wrote in message
...
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))










All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com