
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 09, 2022 07:39 AM
Hi all,
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
Matt
Reply
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 09, 2022 09:56 PM
Hi Matteo, try this:
IF(
FIND("20", Status),
20,
IF(
FIND("40", Status),
40
)
)
