Help needed with IF Expression

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” )

@Martina
You can try with this:

IFS(	
	[Order No]=0,"Requested",
	TRUE,
	IFS(
		NOT([Qty Received]=0),"Received",
		TRUE,"Ordered"
	)
)

Thank you so much. This worked perfectly.

Or:

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

or:

IFS(
  ([Order No] = 0),
    "Requested",
  ([Qty Received] <> 0),
    "Received",
  TRUE,
    "Ordered"
)

Thank you. I think I was making it more complicated than it had to be. One less problem to take into the weekend :grinning:

1 Like