Please help, Returning a blank when cell is blank

[BenHarris]

I am needing to know how to return a blank cell as blank with this formula..

=IF(D6<TODAY()-182,"PPS + 6 Months","PPS - 6 Months")

Currently when there is nothing in the cell, it still returns "PPS + 6 Months"

Basically I am trying to.....
If cell D6's date entry is more than 6 months old, then make cell I6 return "PPS + 6 Months"
If cell D6's date entry is less than 6 months old, then make cell I6 return "PPS - 6 Months"
If cell D6 is left blank, then Leave I6 blank

Thanks

[mehmetcik]

Please Login or Register  to view this content.

[BenHarris]

Thanks Bang on. But now things have changed.

I need to run the same formula, except I need to add in = if a6 is NOT blank then I6 reads "Job Seeker"

What I am trying to achieve is when a person is added to the list(A6), it automatically lists that person as "Job Seeker" (I6). If a start date for their employment is added (H6), I6 will then change to either "PPS + 6 Months" or PPS - 6 Months" depending on input date.

Basically I know I can add "Job Seeker" into the =if(d6="","Job Seeker",IF(D6<TODAY()-182,"PPS + 6 Months","PPS - 6 Months")) However, If I apply this formula down the sheet, it automatically makes the whole I column read "Job Seeker".

I only want it to read "Job Seeker" when H6 is blank BUT only if A6 has some content in it (The persons name).

Thanks for your fast replies.

[mehmetcik]

Please Login or Register  to view this content.

[BenHarris]

Thanks
This works, but as soon as I put a date into d6, it doesnt change to "PPS - 6 Months" it just stays as "Job Seeker".
I need it so it automatically says "Job Seeker", but once a date is entered it changes to "PPS..."

[mehmetcik]

=if(and(A6<>"",d6=""), "Job Seeker",if(d6="","",IF(D6<TODAY()-182,"PPS + 6 Months","PPS - 6 Months")))

[BenHarris]

Thank you so much, This formula is completely beyond me. I can typically read through formulas and make sense of them, but this one leaves me for dead. Thank You soo much for your fast response!

[BenHarris]

Hello All,
I have recently got help from you guys regarding a formula for a excel sheet as follows.. (in cell J13)

=IF(AND(A13<>"",K13=""),"Job Search",IF(K13="","",IF(K13<TODAY()-182,"PPS + 6 Months","PPS - 6 Months")))

This formula works well and I have no issues with it.
However, I now need to add that if cell T13 records "De-Registered", then J13 will return "De-Registered" also.

T13 (actually all of the T column) are "Comments" cells. So if possible it would be only if the cell reads "De-Registered". Any other comments would not affect J13.

Is this possible?

Thanks In advance