I want one formula with different criterias (using IFs and ISBLANK) to get results (not applicable, not required, overdue, due and not yet due) in one

[rajneesh]

The criterias for the formula I need goes something like this.

If M < 40 then "Not required for PIC", If T = "Not applicable" then "Not required for PIC", It T < today's date then "Overdue", If todays date < T and greater than Y (If there is no date in Y column then formula should take date from X column) then "due", If T > todays date then "Not yet due".

Column M contains numbers
Column T contains dates.

Currently what I have entered is as below but am geting error for this formula.

<today(),"overdue",if(today()<=(isblank(y479),x479+90,y479+90),"due","not due"))))
<today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not due"))))
=IF(M479<40,"Not required for PIC",IF(T479="Not Applicable","Not Required for PIC",IF(T479<today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not due"))))
<today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not due"))))

<TODAY(),"Overdue",IF(AND(TODAY()<=ISBLANK(Y479),X479+90,Y479+90),"due","Not yet due"))))
Thanks a lot for helping with the right formula.</today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not></today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not></today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not></today(),"overdue",if(today()<=(isblank(y479),x479+90,y479+90),"due","not>

 

[rajneesh]

.

 

[rajneesh]

[TABLE="width: 561"]
<tbody>[TR]
[TD="width: 102, bgcolor: transparent, align: center"]A
[/TD]
[TD="width: 102, bgcolor: transparent, align: center"]B[/TD]
[TD="width: 252, bgcolor: transparent, align: center"]C[/TD]
[TD="width: 252, bgcolor: transparent, align: center"]D[/TD]
[TD="width: 290, bgcolor: transparent, align: center"]E[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: center"]$40 k[/TD]
[TD="bgcolor: transparent, align: center"]28/09/2014[/TD]
[TD="bgcolor: transparent, align: center"]Formula[/TD]
[TD="bgcolor: transparent, align: center"]01/08/2013[/TD]
[TD="bgcolor: transparent, align: center"]30/06/2014[/TD]
[/TR]
</tbody>[/TABLE]

Dear all,

I have put in the above table to explain the results I am looking for.

Currently the formula that I have written is:
=IF(A1<40,"Not required for PIC",IF(B1="Not applicable","Not required for PIC",IF(B1<today(),"overdue",if(and(today()>=ISBLANK(E1),D1,E1,today()<=B1),"Due",Not yet due"))))

In the above table what I am looking for is:
If coulmn A shows less than 40 k then result should be "Not required for PIC".
If column B shows "Not applicable" then result should be "Not required for PIC".
If date in column B is less than todays date then result should be "Overdue".
If todays date is greater then column E date (if there is no date in column E then column D date needs to be picked) and less than column B date then result should be "Due".
If todays date is less than column E date (if there is no date in column E then column D date needs to be picked) then result should be "Not yet due".

Please let me know if you need any more clarification on this or if you want the file uploaded (currently I dont know if I can upload files in the post). Hoping to find an answer.

Regards,
Rajneesh

The criterias for the formula I need goes something like this.

If M < 40 then "Not required for PIC", If T = "Not applicable" then "Not required for PIC", It T < today's date then "Overdue", If todays date < T and greater than Y (If there is no date in Y column then formula should take date from X column) then "due", If T > todays date then "Not yet due".

Column M contains numbers
Column T contains dates.

Currently what I have entered is as below but am geting error for this formula.

<today(),"overdue",if(today()<=(isblank(y479),x479+90,y479+90),"due","not due"))))
<today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not due"))))
=IF(M479<40,"Not required for PIC",IF(T479="Not Applicable","Not Required for PIC",IF(T479<today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not due"))))
<today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not due"))))

<today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not due"))))
Thanks a lot for helping with the right formula.</today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not></today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not></today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not></today(),"overdue",if(and(today()<=isblank(y479),x479+90,y479+90),"due","not>

</today(),"overdue",if(today()<=(isblank(y479),x479+90,y479+90),"due","not>


</today(),"overdue",if(and(today()>