Hi, I need help with and IF() expression (I think).
I’m trying to write an IF statement on a column [Order Status]. So I will try and explain what I need to achieve.
IF the value of [Order Date] isnotblank = “Order Submitted”, but if the value of [Order Date] isnotblank and the value of [Outstanding Order Total]=0 =“Order Received”. I’m sure it’s pretty simple but can’t seem to figure it out! Thanks in advance