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 · Accepted solution]

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!

[grazitti_sapna]

Hi @malcorr , try this if it works for you. If the columns are empty rather than null then replace isnull with isempty in the formula used.

Formula:

if isnull([Row]) and isnull([Base Dataspec]) then "NOT IN BASE CALC" else [Base Dataspec] endif