Query column to show actual value in record only if it isnt = to valueA or valueB

[Arnold]

Hello all

My column ShippingCost contains values of a dollar amounts and "Free".


I need to run a query where the shipping cost for an Item that = "Free" or "$10.00" (the column is saved as text) should return a blank and all other cells should reflect the actual value.

[ranman256]

=iif([ShippingCost]=0,"Free",[ShippingCost])

[Arnold]

Thank you it worked.