I am attempting to add an if function to a column to calculate quantity of a row based on part description. I have tried search and contains functions to no success. Anytime the part name contains partial I would like to multiply by one. since all other parts are whole, would like to multiply by 4. Any feedback will be appreciated.
Solved! Go to Solution.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.