If, Then formula

[randyrettig]

Hi all,

I need help with a formula/new column.  Basically, if orderprocess[groupno] = 9, and orderprocess[vendorID] has a value, and orderprocess[partnumber] is not 0, return YES, else No.

What I'm trying to do is create a new column that just says Yes or No according the above rules.

I need some inspiration, I'm stuck!

Thanks!

[Idrissshatila · Accepted solution]

Hello @randyrettig ,

use the following calculated column

new column = IF(orderprocess[groupno] = 9 && orderprocess[vendorID] <> BLANK() && orderprocess[partnumber] <>0 , "Yes","No")

The pbix file that I used to create the formula for your reference.

[randyrettig]

Awesome, thank you!