Minus if

[aminsaleh]

Hi, I have an enum type column called "method" in a table called "order"

[Method] has two values "pick up" and "delivery".

----

[Delivery Fees] column has a value for delivery charge.

[Item price] column has a value of the item price.

[Order Total] column auto calculates the total. (delivery fees + items price)

***NOW*** my question is I want a way if the method column is set to "pick up" then it reduces the value of the delivery fees.

Here is the pseudocode how it might be in [order total] column formula:

[Item price]+[Deliver Fees]

And

If [Method] = Pick up

Minus 

[Delivery Fees]

Any help plz