Help needed with IF Expression

[Martina_Hawkins]

I am having problems with syntax of below. Can anyone help me please.

Status:
IF([Order No]=“0” ,“Requested”,“Ordered”)

This part works but when Order is received Status needed to change to “Received”
so when [Qty Received]<> 0 Then Status = “Received”

IF(([Order No] = “0”), “Requested”, IF(([Order No] = “0”), “Ordered”, IF(([Qty Received] <> “0”), “Received”, “???”)))

Also tried this;
IFS(([Order No])=“0”,“Requested”, ([Order No])<>“0”, “Ordered”, ([Qty Received])<>“0”, “Received” )