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
Antony
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |