if two conditions are met , can I return a text message in another collumn?

[tzahranul]

Hello , I am a newfag on this forumand I have a problem. Ok so, first column has the name of some suppliers. seccond collumn has the date of the recieving of some goods(all the data is manual input). in the third collumn I have two answer options (yes/no) based on the fact that a certain date has passed( something like has the product arrived on time? yes/no). I would like to make a 4th collumn in which it would display unsatisfied if date is passed from seccond collumn( date being 31-12-12) and if the answer on the passage of the date is no. I also have to make it show any errors ( like , if I manually change the value of collumn 3 from yes to no , although the date hasn't passed , to display the faulty adress ( E5 for example ) somewhere under the table! If this isn't descriptive enough let me know!

[ben_hensel]

Such terrible formatting... this is the internet, you can skip lines like mad, that's fine, that's good even.

Current state:
A1 = supplier name
B1 = receive date
C1 = boolean

Desire:
D1 = check IF( AND(B1 <> "", B1 <= TODAY() ), "unsatisfied", "something else")

other stuff???

rather than "not descriptive enough", it's "not specific enough".

Check for any errors... what errors? What's even considered an error here?

What makes an address faulty? How would you know?

[tzahranul]

you diserve a medal , doc! thanks a bunch for the quick'n'usefull reply