IF Formula

malcorr

Hello Everyone, 

I'd like an expression so that if i have a value on the "ROW" Column, and the respective value on the "Base Dataspec" column is "null" then i want a message on the "Base Dataspec" Column that reads "NOT IN BASE CALC". If not, then leave as is

Any ideas?

Christine_Assaad

Hi @malcorr 

You will need a formula tool and select “Base dataspec” from the drop down list.

formula should look like this 

if !isempty([Row]) and isempty([Base dataspec]) then “Not in Base Calc” else [Base dataspec] endif

Hope this helps! Cheers!