add to cell formula additional criteria

[steve400243]

Hello, I am using this cell formula to populate the word Shipped in A3 when a date is put into F3.
I need a way for the formula to read "Received" once a date is put into cell D3. Then changing to "Shipped" once a date is put into F3. And Blank if no data is in D3, or F3. Hope that makes sense. Thank you for any help provided.

=IF(F3>1/1/2021,"Shipped","")

 

[Fluff]

How about

=IF(D3="","",IF(F3="","Received","Shipped"))

 

[steve400243]

How about

=IF(D3="","",IF(F3="","Received","Shipped"))

Thank you Fluff, I appreciate the formula. I didn't think about changing mine to D3= "","",If... and getting rid of the >1/1/2021. So much to learn!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[steve400243]

You're welcome & thanks for the feedback.

Hello Fluff, I have an addition to this cell formula you gave me. Can I post it here? or should I open a new posting?

 

[Fluff]

Probably best to start a new thread. Thanks