cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kunuthuri Member
Member

calculated column error?

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: calculated column error?

@kunuthuri

 

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,_____________)

1 REPLY 1
Super User
Super User

Re: calculated column error?

@kunuthuri

 

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,_____________)