Date with Multiple IF Condition Formula

[maheshrk81]

Hi All,

I need a formula for Multiple IF Condition Formula.
In my sheet, Cell D3 - Contails the DATE(manual Input). (Ex:18/04/2012). In Cell A1 it is (D3-30) which is less than 29 days which gives me Less than 30 days list, In cell B1 it is(D3-180) which is less than 180 days which gives me Less than 180 days list, and in Cell C1(B1+1) whcih gives me Greater than 180 days.
In Cells A6, A7 and A8 i have the below list

<TABLE style="WIDTH: 107pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=142><COLGROUP><COL style="WIDTH: 107pt; mso-width-source: userset; mso-width-alt: 5193" width=142><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; WIDTH: 107pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20 width=142>Less than 30 days</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>30 - 180 days</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: white; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>Greater Than 180 days</TD></TR></TBODY></TABLE>

Now my data starts from cell A13 and in Cell D13, i need a formula based on the above.
=IF(A13>=$A$1,$A$6,IF(A13>$A$1<$B$1,$A$7,IF(A13>=$C$1,$A$8)))
This formula is not working correctly.

Please help

Mahi

 

[abi_learn_vba]

Mahi

If i am correct in understading your requirement then I think the logic used in the formula might be incorrect.

First of all i think C1 should contain B1-1 (which give you the date which is greater than 180 days) not B1+1.

Use below formula and let me know if it works for you.

=IF(A9>=$A$1,$A$6,IF(AND(A9<$A$1,A9>=$B$1),$A$7,IF(A9<=$C$1,$A$8)))

Thanks
-Abi

 

[maheshrk81]

Its not working..

 

[abi_learn_vba]

What is not working?

Are you getting any error? Or is the logic given is not what you are expecting?

Provide with an example and your expected result.

-Abi