I need to create a formula column to calculate price of shipping equipments.
I have multiple equipment types in a single select column e.g. (20DV, 20OT, 40DV, 40HC, 40OT)
For all the “20” regardless if it’s DV or OT (same for the 40) the price is the same.
Therefore I need an IF statement kind of like IF Equipment contains “20”, price is …
thanks in advance