calculated column error?

[Anonymous]

Hi

how to write  below query with out errors

column = if (Table1[state]=''Closed" && Table1[Date]<today() -14)

Error: Too few agruments were passed to the IF function . the minimum arguement count for the function is 2

Can you please assist?

Thanks

Kunuthuri

[Zubair_Muhammad · Accepted solution]

@Anonymous

I can also see there is one argument i.e the logical test

You should specify the result too if the logic is met

IF(logical_test>,<value_if_true>, value_if_false) 

column = if (Table1[state]=''Closed" && Table1[Date]<today() -14,_____________)