add additional criteria to formula

[steve400243]

Hello, This formula was provided by Fluff, works great but I need to add to it. If the Date is entered by a user in cell G3, "Ordered" will populate in A3. and if cell N3 is greater than 2, "On Storage" in A3

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

Copy of chicago Report1.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Report Date	8/4/2021												2 free days
2	Status	ON HAND# IN	TRK #	Received Date	On Hand # Out	Shipped Date	Order Date	LOCATION	SHIPPER	PIECES	P.O #	COMPLETE	Days at FTN	Days of Storage	cycle count
3	Received	123	123	8/4/2021
4
5
On Hand

Cell Formulas
Range	Formula
B1	B1	=NOW()
A3	A3	=IF(C3="","",IF(E3="","Received","Shipped"))
A4:A5	A4	=IF(D4="","",IF(F4="","Received","Shipped"))

 

[Fluff]

Duplicate to: need additional criteria added to cell formula.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.