Help with Nested IF arguments, please

Hi Everyone

I hope you can help - Im trying to figure the correct formula and being a slight Excel obsessive with basic formula understanding, im in a pickle!

I want my master Cell (in column N) to write a status based on the entry of a date (any date) of column G to read "Await Collect"

BUT

If column H has a date (any date, always greater than the date in Column F) I want it to read "Gone"

Ive really tried searching under IF with ANY or OR in the argument but my head is mashed.

Your expertise and advice is very much appreciated.

maybe something like this:
=if(and(g2<>"",h2>f2),"Gone",if(and(g2<>"",or(h2<=f2,h2=""))"Await Collect",""))

If you mean the paperclip, they haven't - it doesn't work. Your IT department would not be able to tamper with the way the forum works.

To attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Try this:

=IF(AND(G3<>"",H3<>""),"Gone",IF(G3<>"","Await Collect",""))

Try this in N3:

=CHOOSE(COUNT(G3:H3)+1,"","Await Collect","Gone")

I think you'll find my formula works as well, although I think you might not have noticed it.

Thanks for the rep and for marking the thread as solved.

Oh I am so sorry for not noticing it....forgive me!

Just pointing it out so that you have an alternative approach.